Build an array from a db row

[45246774]

OK, I'm trying to build an array from a mySQL row. I've reserved the first row of a database table as a sort of template for an array. The row contains the default values for each element of the array.

To construct the array in my php script I 'mysql_fetch_assoc' the first row of my database. That gives me an array to work with.

The trouble is I can only access the elements of the array by $some_array['name_of_field'] and not by $some_array[3].

Can someone help me out?

[sfhc]

To get array results with numerical keys:

mysql_fetch_row
(PHP 3, PHP 4 )

mysql_fetch_row -- Get a result row as an enumerated array

[jeremuck]

the problem is you are using "mysql_fetch_assoc".

The problem is in the assoc part which stands for "associative".