Column Listing

[jenniferG]

How do we    get a column listing  from a mysql  table?

Thanks,

Jennifer

[thedarkwinter]

the sql statement is "SHOW COLUMNS FROM mytable"

 

<?php

$result = mysql_query("SHOW COLUMNS FROM mytable");
$row = mysql_fetch_fow($result);
print_r($row);
?>

 

Cheers,

tdw