list of fetch data from mysql

mysql_fetch_array
The most frequently used option is to use function mysql_fetch_array(). This function returns row as an associative array, a numeric array, or both. This function returns FALSE if there are no more rows.

mysql_fetch_assoc
 Fetch a result row as an associative array
mysql_fetch_row
Get a result row as an enumerated array
mysql_fetch_object
The mysql_fetch_object() function returns a row from a recordset as an object.
This function gets a row from the mysql_query() function and returns an object on success, or FALSE on failure or when there are no more rows.

mysql_fetch_field
The mysql_fetch_field() function returns an object containing information of a field from a recordset.

• mysql_fetch_array() - Fetch a result row as an associative array, a numeric array, or both
• mysql_fetch_assoc() - Fetch a result row as an associative array
• mysql_fetch_row() - Get a result row as an enumerated array
• mysql_data_seek() - Move internal result pointer
• mysql_query() - Send a MySQL query