Or like this (to be a little more complete, with comments):
// initialize counter
$count=0;
// start the table and the first row
echo tabletr;
// 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 /trtr;
// 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:[EMAIL PROTECTED]
Sendt: 26. maj 2004 14:28
Til: [EMAIL PROTECTED]
Emne: [PHP-DB] 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