newbie: array of field names?

[marcusb]

Hi

I have a mysql table with field names like
java
java+unix
java+sybase

etc. i am trying to insert these field names into an array called $skills
at the moment i am using this
$skills = array("java", "java+unix", "java+sybase")

But i want to query the database table and get back the field names in this format
"java", "java+unix", "java+sybase"

i have tried using mysql_list_fields and array_fill but no joy
any ideas?

[stolzyboy]

<?
$conn = mysql_connect('localhost', "username", "password")
 or die("Could not connect to mysql");
$db = mysql_select_db("databasename")
 or die("Could not connect to database");

$query = "select * from tablename";
$result = mysql_query($query) or die(mysql_error());

$array = array();
while ($row = mysql_fetch_field($result))
{
array_push($array, $row->name);
}
print_r($array); //will print out the array like key => element
?>