Re: SV: Drawing table by while

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux