Outputting and Entire Mysql Table as an HTML table

[gladiator83x]

Hi All,

I was just wondering if someone could assist me in outputting one of my Mysql tables as an Html table.
I believe that I have to use one of the SHOW TABLE commands that mysql offers.

I was thinking:

$query="SHOW TABLE_NAME";
$result="mysql_query($query)";

Any suggestions?

[manichean]

Hello gladiator83x,

Have a look here
http://www.biorust.com/tutorials/detail/221/en/

cheers

[Barand]

try this
[code]
<?php
$result = mysql_query("SELECT * FROM tablename");

echo "<TABLE border='1' cellpadding='4'>\n";

// column headings
      echo "<tr>\n";
      while ($fld = mysql_fetch_field ($result)) {
              echo "<th>{$fld->name}</th>\n";
      }
      echo "</tr>\n";
     

// list data
      while ($row = mysql_fetch_row($result)) {
      echo "<tr>\n";
      foreach ($row as $field) {
              echo "<td>$field</td>\n";
      }
      echo "</tr>\n";
}

echo "</TABLE>\n";
?>
[/code]