MySQL data display

Anon

Below is the code I'm using that does not work. The first while loop uses the columns in $result to display on the fields. Then, I want to display all of the data that is in the table under each correct heading. How can I do this?

$result = mysql_query("show columns from table",$connection) or die ("Couldn't execute query.");

$data = mysql_query("SELECT * from $table ORDER BY productid",$connection) or die ("Couldn't execute query.");

while ($field = mysql_fetch_array($result))
{
echo "<td>$field[0]</td>";
}
echo "</tr>";

echo "<tr>";
$count = 0;
while ($field = mysql_fetch_array($data))
{
echo "<td>$field[$count]</td>";
$count += 1;
}
echo "</tr>";

Anon

i am afraid u didnt understand well how mysql_fetch_array works.

when u use mysql_fetch_array on a SQL query result, it store the first line of fields.

example of a database:
structure is: firstname lastname town
$field = mysql_fetch_array( $result )
$field[0] = "John"
$field[1] = "Wayne"
$field[2] = "Texas"
$field = mysql_fetch_array( $result )
$field[0] = "Michael"
$field[1] = "Douglas"
$field[2] = "New York"
etc...

hope this help
cheers