HTML creation

[thoand]

Hi,

How do you build a HTML table generated from a database,

What I want is foreach 5 records build a new column on the page

like
<td>
record 1
record 2
record 3
record 4
record 5
<td>
Reached 5
create a new <td>

Contiue ...

If you have Oulook 2000, see the contact list to see what I am talking of.

best regards,
Thomas A.

[LordShryku]

Here's an idea. Untested, so play with it

<?php
$sql = "SELECT blah FROM table";
$res = mysql_query($sql);
$rows = mysql_num_rows($res);
if($rows == 0) {
   // nothing to display
}
else {
   $i = 0;
?>
<table border="1">
  <tr valign="top">
    <td>
<?php
   while($row=mysql_fetch_array($query)) {
      echo $row['blah'];
      $i++;
      if(($i%5)==0) {
?>
    </td>
    <td>
<?php
      }
      else {
         echo "<br />";
      }
   }
   if(($rows%5) != 0) {
?>
    </td>
<?php
   }
?>
  </tr>
</table>
<?php
}

[thoand]

It worked out OK,
thanks,

Thomas

[LordShryku]

Sorry for my lack of comments. Did you want/need me to explain any of it?

[thoand]

No problem, I understood it.
I just could not figure out the trick in the beginning.