is it possible to run the query:
describe table
using php script and if so how would it be done. Thanks for any help. It's greatly appreciated. I've tried but i can't get it to display the info how it would using mysql.
Printable View
is it possible to run the query:
describe table
using php script and if so how would it be done. Thanks for any help. It's greatly appreciated. I've tried but i can't get it to display the info how it would using mysql.
I have not ever tried it...
(time to experiment! ;))
The output format bites, but it gives you something to work with:
PHP Code:$query = "DESCRIBE [table name]";
mysql_query( $query );
while( $row = mysql_fetch_row($result) )
{
foreach( $row as $element )
{
$bodyContent .= $element . " : ";
}
}