Converting Function to return MYSQL_ASSOC information

[Helza]

Hi,

I really need some help with the following, i have a function which returns an 2 dimentional array (i believe you call it that way?) from a MySQL query..

However this function returns an numerical array (?) with value's like Array[0][0], Array[0][1] etc... however i need this function to return an ASSOCIATIVE array, like Array[0]["id"] Array[0]["name"] etc

(the first dimention of the array can still be numerical, thats no problem)
Could anyone help please?

[Chen]

Use mysql_fetch_array() instead of mysql_fetch_row(), and set the second argument of the former to MYSQL_ASSOC if you only want it to return an associative array only. (otherwise it will also store the values in numeric indexes)

[Helza]

got it

Thanks for the help..