Find the data with row number 3 in the result set:
// Assume database username: root, password: 123456, database: CODERCTO $con=mysqli_connect("localhost","root","123456","CODERCTO"); if (mysqli_connect_errno($con)) { echo "Connect MySQL failed: " . mysqli_connect_error(); } $sql="SELECT name,url FROM websites ORDER BY alexa";if ($result=mysqli_query($con,$sql)){ //Look for data with row number 3 mysqli_data_seek($result,2); //Read data $row=mysqli_fetch_row($result); printf ("name: %s url: %sn", $row[0], $row[1]); // Release the result set mysqli_free_result($result);}mysqli_close($con);?>The mysqli_data_seek() function adjusts the result pointer to an arbitrary row in the result set.
mysqli_data_seek( result,offset ) ;
| parameter | describe |
|---|---|
| result | Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result(). |
| offset | Required. Specifies field offset. The range must be between 0 and the total number of rows - 1. |
| Return value: | Returns TRUE if successful and FALSE if failed. |
|---|---|
| PHP version: | 5+ |