gladiator83x Posted July 25, 2006 Share Posted July 25, 2006 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? Quote Link to comment Share on other sites More sharing options...
manichean Posted July 25, 2006 Share Posted July 25, 2006 Hello gladiator83x,Have a look herehttp://www.biorust.com/tutorials/detail/221/en/cheers Quote Link to comment Share on other sites More sharing options...
Barand Posted July 25, 2006 Share Posted July 25, 2006 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] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.