[SOLVED] Print out mysql DESCRIBE?

[Perad]

Take this example.

 

$sql = "DESCRIBE users";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
foreach ($row as $key => $val) {
print $key . " - ". $val. "<br />";
}

 

This only prints out the first field in the table. How do I use php to print them all?

[only one]

while($row = mysql_fetch_assoc($result)){

foreach ($row as $key => $val) {

print $key . " - ". $val. "<br />";

}

}

[Perad]

of course, duh