get field names from table?

[halfasleeps]

what is the query to get all the field names of a table?

I am trying to create an array in PHP to hold the field names of a perticular table.

Thanks!

[longneck]

describe tablename

[halfasleeps]

describe tablename

OK say I have a database

on this database I have a table named products

the products table as an uncertain ammount of fields in it (ie: 'name', 'price', 'description') I need to get a list of all of those fields??

THanks.

[halfasleeps]

I figured it out....

$all_rows = array();
$sql = "SHOW COLUMNS FROM `product`";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
    array_push($all_rows,$row['Field']);
} 

[Dan Grossman]

OK say I have a database

on this database I have a table named products

the products table as an uncertain ammount of fields in it (ie: 'name', 'price', 'description') I need to get a list of all of those fields??

THanks.

He was giving you the answer DESCRIBE is a MySQL command. It describes the table definition.

[halfasleeps]

He was giving you the answer DESCRIBE is a MySQL command. It describes the table definition.

Ohh hahaha....I was wondering how could he know the answer if he needed me to describe what a table was lol

Thanks.

[r937]

Quote (longneck):
describe tablename

OK say I have a database

on this database I have ...

i had a real strong hunch that was gonna happen

i would at least have used code tags and italics:

describe tablename

[longneck]

hey, both commands are easily available in the mysql manual. i had to make the poster at least work a little bit.