mysql_fetch ???

[tbobker]

I have read the php manual and still cant grasp why you would use any one of the following:

mysql_fetch_array()
mysql_fetch_assoc()
mysql_fetch_row()
mysql_fetch_object()

they all get the asscociated array from the database so whats the difference?

and why do people sometimes use mysqli rather then mysql ?

[tomhath]

mysql_fetch_array() - indexed array or associative array
mysql_fetch_assoc() - associative array only
mysql_fetch_row() - indexed array only
mysql_fetch_object() - associative array or your own class

mysql - for earlier versions of MySQL database (prior to 4.1.3)
mysqli - backward compatible with earlier versions, but added functionality for new