Entry

Why does mysql_fetch_array return a Resource instead of an Array?

Jan 24th, 2001 22:54
Joshua Ariizumi, mark romero, Onno Benschop, http://www.php.net/mysql_fetch_array

mysql_fetch_array() is the "deluxe" version of mysql_fetch_row().  
While mysql_fetch_row() returns a simple linear array of the results, 
mysql_fetch_array() returns an array that has both index and column 
name, so with
  $r = mysql_fetch_array($result);
you can refer to columns like
  echo $r["name"];
or
  echo $r[0];
which would be the same, assuming your first column in the result set 
was "name".
Manual Links:
http://www.php.net/mysql_fetch_array
http://www.php.net/mysql_fetch_row