How do I get the MySQL table structure in PHP? Plus a list of all tables?

Question

What query do I need to run in PHP to get the structure of a given table in the database? And what query do I need to run to get a list of all the tables?

Answer 1

To get a list of columns for a table, use the DESCRIBE SQL statement. The syntax is as follows:

DESCRIBE TableName 

To get a list of tables on the database, use this SQL statement:

SHOW TABLES 

Answer 2

$q = mysql_query('DESCRIBE tablename'); while($row = mysql_fetch_array($q)) {     echo "{$row['Field']} - {$row['Type']}\n"; } 

found it at http://www.electrictoolbox.com/mysql-table-structure-describe/