fetching data using "mysql_fetch_assoc"

i can fetch data using mysql_fetch_array in SHOW TABLE STATUS (http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html) command but why can not i fetch data using mysql_fetch_assoc ?




$con = mysql_connect("localhost", "root", "123") or die(mysql_errno()."<br/>". mysql_error());
mysql_select_db("forum",$con);
$sql = "SHOW TABLE STATUS FROM forum";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
echo $row["Name"];
echo $row["Engine"];
echo $row["Data_length"];
}
how can i fetch table calles user' properties using this parameter
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

how can i fetch table calles user' properties using this parameter
You can specify the table with the LIKE clause:
// you shouldn't need the "FROM forum" part, but if it doesn't work try adding it before the LIKE
$sql = "SHOW TABLE STATUS LIKE 'user'";

You can specify the table with the LIKE clause:
// you shouldn't need the "FROM forum" part, but if it doesn't work try adding it before the LIKE
$sql = "SHOW TABLE STATUS LIKE 'user'";


thanx it runs but i want to do this proccess all tables in db (using SHOW TABLE STATUS command)

Your original code should work fine, then.