[Resolved] array of column names

[happyme]

I want to put the column names from an sql query into an array

I've tried using

$myfields = mysql_fetch_array($result);

while ( list($key,$value,) = each($myfields))
	{
	echo " key ".$key;
	echo " -  value ".$value;
	echo "<br>";
	}

but it gives me the column names AND the column numbers. Is there a way to just get the names?

Julia

[happyme]

I know my example above won't put the values into an array, but by using echo I can check what's happening - if I can display a list of column names, I can put them in an array easily.

[happyme]

solved
I was looking for column names, but I should have been looking for field names

echo mysql_field_name($result, 0);

gives me what I want

[tekky]

[man]mysql_fetch_assoc/man

or

[man]mysql_fetch_array[/man]($result, MYSQL_ASSOC)

reading the the Tutorials and the documents on what you are using can help you out immensly

these will accomplish what you were looking for and return the data from the fields too