Displaying Fields and Data of a MySQL Table

We often have to view MySQL tables in a tabular form without the SQL query console. Sometimes you have to see what all fields are there in a MySQL table and what information they contain. The following piece of code presents to you a tabular format of your table and its contents.

<?php
$query="select * from table_name";
$result=mysql_query($query);
echo "<table border=1>";
echo "<tr>";
for($i=0;$i<mysql_num_fields($result);$i++)
{
   echo "<th>";
   echo mysql_field_name($result, $i);
   echo "</th>";
}

while($row=mysql_fetch_row($result))
{
   echo "<tr>";
   for($j=0;$j<$i;$j++)
   {
    echo "<td>";
    echo $row[$j];
    echo "</td>";
   }
   echo "</tr>";
}
echo "</tr>";
echo "</table>";

?>