Something like this: echo '<table>'; $count=1; while ($myrow = mysql_fetch_array($sql)) { If ($count==5) { echo "</tr>"; $count=1; } If ($count==1) echo "<tr>"; $count++; echo $myrow[0]; } echo '</table>'; Hth Henrik Hornemann -----Oprindelig meddelelse----- Fra: nabil [mailto:nabil.attar@xxxxxxxxxxxxx] Sendt: 26. maj 2004 14:28 Til: php-db@xxxxxxxxxxxxx Emne: Drawing table by while Hiya, How can i draw a new <tr> AFTER FIVE <td> in the following loop (i want to echo the records in 5 columns width tables whatever the number of records will be fetched) .. echo '<table>'; while ($myrow = mysql_fetch_array($sql)) { echo $myrow[0]; } echo '</table>'; ------------------------------ | x | y | z | o | ------------------------------ | f | q | h | hj | ------------------------------ . . . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php