print column names

[gilgalbiblewhee]

Maybe this is posted in the wrong forum. I need to print out the column names of a database table with php.

[curtiss]

You can run either of the following queries:

PHP Code:

DESC $table; 


or

PHP Code:

SHOW COLUMNS FROM $table 


Both queries will return the same results. Within those results, the column that you want will be called "Field".

Therefore, your PHP might look something like:

PHP Code:

$cols = array();
if($sql = mysql_query("DESC mytable",$link)) {
while($rows = mysql_fetch_assoc($sql)) {
$cols[] = $rows['Field'];
}
}