You could use this script: <?php $columns = 3; $count = 0; while ($query_data = $yoursearch){ $count++; if ($count < $columns) { echo "<td>$query_data[]</td>"; } else if ($count == $columns) { $count = 0; echo "<tr><td>$query_data[]</td>"; } for ($i=$count;$i<=$columns;$i++){ echo "<td> </td>"; } echo "</tr>"; } ?> I think it works. Bye, Moreno
-----Messaggio originale----- Da: Dave Carrera [mailto:[EMAIL PROTECTED]] Inviato: lunedi 18 febbraio 2002 13.07 A: php List Oggetto: [PHP-DB] I cant get the logic for this... Hi all, I want to display return results from my query (which works fine) In I tidy way on screen. So my result returns say seven results, I have a table, and I want to show 3 results per row of the table... I.e.: Table TR TD = result1 /TD TD result2 /TD TD = result3 /TD /TD /TR TR TD = result4 /TD TD result5 /TD TD = result6 /TD /TD /TR TR TD = result7 /TD TD resultempty /TD TD = resultempty /TD /TD /TR /table The last two td in row 3 are empty because result found 7 results. This cant be fixed so echo statements wont work as the result could Be 3 or 10 or 56 or whatever..... As Always your help and or guidance in this matter is appreciated. Dave Carrera Php / MySql Development Web Design Site Marketing http://www.davecarrera.com -- 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