Connecting Tech Pros Worldwide Forums | Help | Site Map

How do I line up SQL query results 3 across the page?

skinnybloke
Guest
 
Posts: n/a
#1: Dec 23 '05
Hi - can anybody point me to a tutorial to do the following:


I am running a SQL SELECT statement which returns the URL addresses of
images which when clicked on will link to another page - no problem in
doing that.

What I am having difficulty in is lining these up in a html table 3
images across the page.

i.e.

<table>
<tr>
<td>image</td>
<td>image</td>
<td>image</td>
</tr>
<tr>
<td>image</td>
<td>image</td>
<td>image</td>
</tr>
</table>

Any help would be appreciated.

John Meyer
Guest
 
Posts: n/a
#2: Dec 23 '05

re: How do I line up SQL query results 3 across the page?


skinnybloke wrote:
[color=blue]
> Hi - can anybody point me to a tutorial to do the following:
>
>
> I am running a SQL SELECT statement which returns the URL addresses of
> images which when clicked on will link to another page - no problem in
> doing that.
>
> What I am having difficulty in is lining these up in a html table 3
> images across the page.
>
> i.e.
>
> <table>
> <tr>
> <td>image</td>
> <td>image</td>
> <td>image</td>
> </tr>
> <tr>
> <td>image</td>
> <td>image</td>
> <td>image</td>
> </tr>
> </table>
>
> Any help would be appreciated.[/color]


The modulus operator in the while loop you're fetching the results in works
wonders. Basically, set up a counter, check to see if the counter modulus
3 = 0. If it does, break off that row and start a new one.
skinnybloke
Guest
 
Posts: n/a
#3: Dec 24 '05

re: How do I line up SQL query results 3 across the page?


Thanks - I'll give that a Go,

On Fri, 23 Dec 2005 09:09:18 -0700, John Meyer
<john.l.meyer@gmail.com> wrote:
[color=blue]
>skinnybloke wrote:
>[color=green]
>> Hi - can anybody point me to a tutorial to do the following:
>>
>>
>> I am running a SQL SELECT statement which returns the URL addresses of
>> images which when clicked on will link to another page - no problem in
>> doing that.
>>
>> What I am having difficulty in is lining these up in a html table 3
>> images across the page.
>>
>> i.e.
>>
>> <table>
>> <tr>
>> <td>image</td>
>> <td>image</td>
>> <td>image</td>
>> </tr>
>> <tr>
>> <td>image</td>
>> <td>image</td>
>> <td>image</td>
>> </tr>
>> </table>
>>
>> Any help would be appreciated.[/color]
>
>
>The modulus operator in the while loop you're fetching the results in works
>wonders. Basically, set up a counter, check to see if the counter modulus
>3 = 0. If it does, break off that row and start a new one.[/color]

Thanks - I'll give that a Go,
Closed Thread