Thread: what is the difference between mysql_fetch_row and mysq_fetch_array

In an enumerated array each column is stored in an array offset starting from 0 (zero).
Elements of the enumerated array are number.

For example, See the output of both mysql_fetch_row, mysql_fetch_array and mysql_fetch_assoc for a query that out puts two fields client_id and client_name

mysql_fetch_row
Array ( [0] => 3 [1] => ABC Solutions )

mysql_fetch_array
Array ( [0] => 3 [client_id] => 3 [1] => ABC Solutions [client_name] => ABC Solutions )

mysql_fetch_assoc
Array ( [client_id] => 3 [client_name] => ABC Solutions )

Originally Posted by Lokesh M

In an enumerated array each column is stored in an array offset starting from 0 (zero).
Elements of the enumerated array are number.

I am so confused.With the part color of red, if i use the while loop to fetch all the records,then i can use the numeric index to get the elements.
So that ,whether an enumerated array equal to a numeric array.

Yes by definition of Numeric array - An array with a numeric index, enumerated array can be said be numeric array.

Thank you! Lokesh M

So mysql_fetch_row() and mysql_fetch_array() can be used in place of each other? Are they interchangeable?