Hi all

Are these two essentially(maybe exactly) doing the same thing or is there a difference.

I'm trying to work out if it's just a matter of choice when to use one and not the other.

Code:

//from book, learning Mysqli
$row = $result->fetch_array(MYSQLI_ASSOC)

//what i've seen:
$row = $result->fetch_assoc(); 

LT :D

They are functionally the same. You can get more information from the manual page.

Thanks knowledge

Yep a bit more reading

OK
came across this on the other page

mysql_fetch_assoc() is equivalent to calling mysql_fetch_array() with MYSQL_ASSOC for the optional second parameter. It only returns an associative array.

fetch_array can return an indexed array, an associative array or both while fetch_assoc will return only an associative array.

Personally I prefer to use mysql_fetch_assoc() because the keys in the array are the actual column names returned by the original sql query.

mysql_fetch_array returns both types of arrays by default which is a waste imo unless you need both for some reason.