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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • skinnybloke
    #1

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

    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.
    Tags: None
    • John Meyer
      #2
      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.

        Comment

        • skinnybloke
          #3
          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@g mail.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,

            Comment

            Previous template Next
            Working...