[RESOLVED] want to get field name of result query

[qadeer_ahmad]

Hi,

I want to get name of the fields of a result query i.e. i have a query

$result=mysql_query("select * from reports order by report_id desc");

One thing is clear here i don't know how many fields present here above query is a example bcoz actul is a too much long query that's why i am using a simple query. i can get value easily like this

while($row=mysql_fetch_array($reslult))
{
$abc=$row[0];
}

but i need here the name of the field.

Any idea here?

[drew010]

if you did
$row = mysql_fetch_array($result);
you could then do
print_r($row);
and it will list all of its indices, which would show the names of all the keys.

if you needed to do it programatically, you could use [man]array_keys[/man] to return an array of all the keys, and then you can loop through the array, listing all the non-numeric keys.

[qadeer_ahmad]

Second option is my required but when i use it like this
$result=mysql_fetch_array(mysql_query("select * from reports"));
print_r(array_keys($result));

it give me this

Array ( [0] => 0 [1] => report_id [2] => 1 [3] => sql [4] => 2 [5] => critaria [6] => 3 [7] => report_dt [8] => 4 [9] => name )

as thier are my required name present but if u see here [0] , [2], [4], [6], [8] are not my required data how can i remove it?

[drew010]

try calling mysql_fetch_array like this

print_r(mysql_fetch_array($row, MYSQL_ASSOC));

[qadeer_ahmad]

Thanks drew010 ,

Problem is solved