Counting tables? and getting table data??

[AbydosGater]

Hey,
With rows you can use mysql_num_rows, to get the number of rows, and then loop a code to get and display all the row information....

But how would you go about getting the information on tables in a database?

Thanks
Abydos

[blear]

[code] $query= " describe userInfo ";
$userInfoQuery=mysql_query($query);

while($row=mysql_fetch_row($userInfoQuery)){

  echo $row[0] . "<BR>";

}[/code]

This will display all the fieldnames of the table userInfo

[AbydosGater]

Thanks thats great... But is there way to loop this through all the tables in a database?