mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]

Possible Duplicate:
mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object

I want a function which can return fields in the current row of a resultset into an associative array and moves the result pointer to the next row.

Confused between

mysql_fetch_row()
mysql_fetch_assoc()
mysql_fetch_array()

Which one should I use? Any help would be appreciated. Thank you.

Solution 1:

^{Note: The use of the mysql_* functions are considered deprecated and you should instead use something that offers better security and more functionality, such as MySQLi or PDO.}

What is it?

You are looking for mysql_fetch_assoc, as the name implies it will return an associative array (with the column names as keys and the values as the row values).

What will the different functions return?

All of the mentioned functions will return an array, the differences between them is what values that are being used as keys in the returned object.

• mysql_fetch_row

  This function will return a row where the values will come in the order as they are defined in the SQL query, and the keys will span from 0 to one less than the number of columns selected.

• mysql_fetch_assoc

  This function will return a row as an associative array where the column names will be the keys storing corresponding value.

• mysql_fetch_array

  This function will actually return an array with both the contents of mysql_fetch_rowand mysql_fetch_assoc merged into one. It will both have numeric and string keys which will let you access your data in whatever way you'd find easiest.

  It is recommended to use either _assoc or _row though.

Solution 2:

mysql_fetch_assoc when you are manually referring to the fields.

mysql_fetch_row when you are using it as part of a list($a,$b,$c...) = ...

Never mysql_fetch_array.

Solution 3:

mysql_fetch_assoc()

Say your table has two columns id and name. You can use the following snippet -

while ($row = mysql_fetch_assoc($result)) {
    echo $row["id"];
    echo $row["name"];
}