DESCRIBE TABLE and php

[sdizier]

Hi all.
I would like to use the DESCRIBE TABLE command in php to display table info. Any ideas how to do this?

Thanks
Slan

[killerbishop]

This is still just a regular MySQL query. Try:

$result = mysql_query("DESCRIBE TABLE table");
$data = mysql_fetch_assoc($result);
print_r($data);

[MytchE]

Just setup a loop on the recordset and print them out... if you want create a PHP class and create a new class instance for each field.

[sdizier]

Thanks folks
Slan