PHP and SQL Output Question

[Anon]

Hey people and thanks for all your continued help so far.

I am connecting do my database and outputting the results on the HTML page. When I use the WHILE statement to keep showing rows as long as they are there to show, I need to format the page to have 2 columns per page so that my output looks like this:

Seth Cox Randy Cox
Address Here Address Here
City, ST Zip City, ST Zip

Next row, and so on.....2 columns per row

Instead, all I can get it to do is this:

Seth Cox
Address Here
City, ST ZIP

Randy Cox
Address Here
City, ST ZIP

next row.......etc.

Since I don't need to close my </tr> until 2 columns, how can I tell my while statement to go to the next SQL row and to close my <tr> after every TWO SQL rows displayed?

I hope you can understand what I am trying to do - all help is appreciated.

Thanks!

Seth

[Anon]

Increment a counter and then mod that counter to see if you are at an even number (or whatever increment you want to test for):

if ( $counter++ % 2 == 0 ) {
// Close existing row and insert a new one here
}

That should do the trick... If I didn't explain it very well, send me an email...

• Brad