The easiest way would be nested tables. Your three "columns" would each have
a nested table within them where you loop through 1/3 of the results. Some
simple math functions and the result of mysql_num_results() should tell you
how many to loop through in each table.
<table>
<tr>
<td>
<table>
<tr><td>aaaa</td></tr>
<tr><td>aaab</td></tr>
</table>
</td>
<td>
<table>
<tr><td>bbba</td></tr>
<tr><td>bbbb</td></tr>
</table>
</td>
<td>
<table>
<tr><td>ccca</td></tr>
<tr><td>cccb</td></tr>
</table>
</td>
</tr>
</table>
---John Holmes...
----- Original Message -----
From: "Awlad Hussain" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 9:58 AM
Subject: [PHP] Automatic Table Creation
I have a mysql table containing about 100 record, alphabetically ordered.
How would i display them in browser in a 3 columns, doesn't matter how long
the rows is as the number of records will grow in the database table.
the records should be in alphabetically order, for example:
aaa bbba ccca
aab bbbb cccb
aac bbbc cccc
aad bbbd cccd
any idea anyone?
awlad
_______________________________________________________________________
Sheridan Phoenix Company
The Business Centre Kimpton Road Luton Bedfordshire LU2 0LB
Email: [EMAIL PROTECTED]
Phone: 01582 522 330
Fax: 01582 522 328
_______________________________________________________________________
This electronic transmission is strictly confidential and intended
solely for the addressee. If you are not the intended addressee, you
must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error it would
be helpful if you could notify The Sheridan Phoenix Company Ltd as soon
as possible.
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of The
Sheridan Phoenix Company Ltd.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
