mysql_fetch_row Function in PHP

What is mysql_fetch_row() function in PHP?
How does mysql_fetch_row works?


mysql_fetch_row() function fetches a row of data from a result handle and returns it as an numerically keyed array.
array mysql_fetch_row ( resource result)

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
mysql_fetch_row() fetches one row of data from the resultset returned by mysql_query(). The row is returned as an numerically keyed array.
To get the value from the array we have to use array offset starting from 0. Each call to this mysql_fetch_row function returns the next record. Here one record is returned at a time and returns false if there is no more record to return.
// Attempt to connect to the default database server
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");
//returns result set on executing the query
$rst=mysql_query("select * from employee",$link);
echo "id,name,salary<br>";
//fetches each row of result set as an array
//display the values using numeric array index
echo "$res[0],$res[1],$res[2]<br>";

In the above code mysql_query() executes a simple query and returns a resultset '$rst'. Resultset is passed as a parament to the mysql_fetch_row function to fetch each record of the resultset '$rst'.
mysql_fetch_row function returns record as a numerically indexed array '$res', it returns one record when each time it is called. This array can be accessed with the numeric array index starting from '0' to the length of the array.
Id name salary
1 John 6000
2 Alex 4000
3 Antony 9000
4 Mercy 4500

See also: mysql_fetch_array(), mysql_fetch_assoc(), mysql_fetch_object(), mysql_data_seek(), mysql_fetch_lengths() and mysql_result()

PHP Topics

Ask Questions

Ask Question