creating a table in html

[johnnyblaze9]

How do I create a table in html using my sql database and php?

[DarkWater]

Set up a new row on every iteration of a while loop that gets the MySQL results.  I'll post an example if you don't get it.

[Styles2304]

just a quick example:

 

<table width="100%" cellpading="0" cellspacing="0" border="0">

<?php
$query = "SELECT Data FROM Main ORDER BY RAND() LIMIT 5";

$result = mysql_query($query, $link)
  or die(mysql_error());

  $main = ' ';
  
while ($row = mysql_fetch_array($result)) {
  $Data = $row['Data'];

  $main .=<<<EOD
     <tr>
      <td>
        $Data
      </td>
    </tr>

EOD;

}

echo $main;
?>

</table>

[johnnyblaze9]

Thanx!