MySQL columns

[Anon]

How can I bring up a list of columns in PHP without bringing up the type, null, key, etc. I only want the fields in the column so I can display them in an administrative HTML table.

"show colums from table" does not work because it brings up the type and everything else.

[Anon]

See mysql_list_fields() function.

[Anon]

You can use "show columns from table," just don't print out the information you don't want.

$result = mysql_query("show columns from table");
while($row = mysql_fetch_row($result))
{
echo "Field: " . $row[0];
}

---John Holmes...