referencing column names from mySQL resource

brainfuelmedia

I have a resource that is returned from a mySQL query in php (mysql_query() -> mysql_fetch_array()), and am wondering how I can print out the column names.

The mysql_fetch_array() function returns an associative array, does it not? Why then can I not directly print out the first part of the association? Basically using a $key, $val in a foreach loop.

I'm probably missing something but would appreciate any help I could get on this one.

Thanks!

ShadowMetis

I haven't used the function in a while but I believe it's something like this. You would declare it like this:
$myvar = mysql_fetch_array();

And then the array would be in the variable, $myvar. So the first piece of information would be $myvar[1].

brainfuelmedia

Thank you. I do understand how mysql_fetch_array() works, but I'm wondering how I can reference the actual 'field'.

In the example you gave above, you showed $myvar[1]. What if didn't want to know the contents of the association, but rather the name of the association at [1].

In other words, if I didn't know name of the field at location [1], how could I find out the field name?

laserlight

By using [man]mysql_field_name/man, or by DESCRIBE TABLE.

brainfuelmedia

Thank you.

I'll take a look in to it.