Result Set Of Mysql Be Handled In Php. Each row is stored in an array row and the attribute values in the array are extracted in Step 4. While mysql_result is a generally terrible function it was useful for fetching a single result field value from a result set for example if looking up a users ID.
The result set can be handled using mysql_fetch_array mysql_fetch_assoc mysql_fetch_object or mysql_fetch_row. It can take a MySQL query result set resource handle as parameter and provides several types of functions to access the data from the result set. How the result set of Mysql be handled in PHP.
You can suggest other answer in comment box.
While mysql_result is a generally terrible function it was useful for fetching a single result field value from a result set for example if looking up a users ID. These functions get the current row from the result set and return it as a standard PHP array or object. The result set can be handled using mysql_fetch_array mysql_fetch_assoc mysql_fetch_object or mysql_fetch_row. For example executing the function for a result_set with a row parameter of 10 and then issuing a mysql_fetch_row mysql_fetch_array or mysql_fetch_object retrieves the tenth row of the result set.