Double data-amount from mysql_fetch_array

[Frozty85]

Hello everyone!
I've previously been working with mysql_fetch_array alot, BUT, just resently I noticed that it returns this result when dumping the array:

Array
(
[0] => 8
[id] => 8
[1] => borr 3.JPG
[imgname] => borr 3.JPG
[2] => varme
[category] => varme
[3] => dfsdsddsdsffff
[title] => dfsdsddsdsffff
[4] => dfssdgggg
[description] => dfssdgggg
)

The query is:

$dbFiles = mysql_fetch_array(mysql_query("SELECT * FROM installations")); 
print_r($dbFiles);

And the database contains the fields:
id, imgname, category, title, description

But NONE of the numbers, so why do I get this result from the function?

[laserlight]

That's because mysql_fetch_array() combines the result of both mysql_fetch_row() and mysql_fetch_assoc().

Just use mysql_fetch_assoc() instead, in this case.

[Frozty85]

THanks for the quick reply, actually the code isn't as simple as the one I posted here, so I think I'll stay with mysql_fetch_array..

I just wanted to know why mysql_fetch_array behaved that way.

Many thanks