Or like this (to be a little more complete, with comments):
// initialize counter
$count=0;
// start the table and the first row
echo "<table><tr>";
// loop through fetch results
while ($myrow = mysql_fetch_array($sql))
{
// if we've output 5 columns...
if ($count==5) {
// end the current row, start another
echo "</tr><tr>";
// and reset our counter
$count=0;
}
// output the next cell in this row
echo "<td>".$myrow[0]."</td>";
// and increment the counter
$count++;
}
// end the row and the table
echo '</tr></table>';
I've used this type of code before, but have not checked the specific code
above for spelling or other typographic errors.
The example code posted earlier (see below) had a small error in that the
counter was incremented twice if it was the first column, therefore only
printing 4 columns.
:Mike S.
:Austin TX USA
> 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
