Jump to content

Archived

This topic is now archived and is closed to further replies.

gladiator83x

Outputting and Entire Mysql Table as an HTML table

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.