Populating a table on a php web page fro

[Anon]

I have a problem with inserting my data across the page. I would like to have it show in 3 columns and X rows. I have no problem pulling my data from the database to my php page and displaying it in one column with X rows. I have 400 towns and would like them sorted alphabetically in 3 columns and X rows . John

[Anon]

Hi,

I'm assuming from your post that you want three columns of towns to make the table more compact.

First, you need to work out how many towns there are, using

$num_towns = mysql_num_rows($my_query_result);

[are you using mysql?].

Then divide the number of towns by three, and round up to the nearest integer. Use three separate loops to create three tables within one "outer" table (for alphabetically down, then across).

OR

Use on loop that uses three <td>$town</td> per row for alphabetically across, then down. In this second option, you'll need to move the result array pointer between each instance of $town.

DO NOT FORGET to detect if the result array is empty in your loop. Not all lists will divide by three evenly so you'll need to put in a few <td>&nbsp;</TD> items to fill out the remainder of the table.

Netscape is particularly sensitive to tables that "don't add up" if you forget the remainder table cells.

Hope this helps.

Cheers,
Duncan.

[Anon]

Hi Duncan,
Thank you for the reply, now
1) Yes to more compact.
2) Yes to mysql.
3) Can you give me a snippet of code please to show me how to do this if not
can you point me to a web site that might have it. Again thank you John.