php man page for mysqli_data_seek

MYSQLI_DATA_SEEK(3)							 1						       MYSQLI_DATA_SEEK(3)

mysqli_result::data_seek - Adjusts the result pointer to an arbitrary row in the result

       Object oriented style

SYNOPSIS
       bool mysqli_result::data_seek (int  $offset)

DESCRIPTION
       Procedural style
       bool mysqli_data_seek (mysqli_result  $result, int  $offset)

	The mysqli_data_seek(3) function seeks to an arbitrary result pointer specified by the $offset in the result set.

PARAMETERS
	      o $
		result	 -Procedural   style   only:   A   result   set   identifier   returned   by  mysqli_query(3),	mysqli_store_result(3)	or
		mysqli_use_result(3).

	      o $offset
		- The field offset. Must be between zero and the total number of rows minus one (0..mysqli_num_rows(3) - 1).

RETURN VALUES
	Returns TRUE on success or FALSE on failure.

NOTES
       Note

	       This function can only be used with buffered results attained from the use of the mysqli_store_result(3) or  mysqli_query(3)  func-
	      tions.

EXAMPLES
       Example #1

	      Object oriented style

	      <?php
	      /* Open a connection */
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      $query = "SELECT Name, CountryCode FROM City ORDER BY Name";
	      if ($result = $mysqli->query($query)) {

		  /* seek to row no. 400 */
		  $result->data_seek(399);

		  /* fetch row */
		  $row = $result->fetch_row();

		  printf ("City: %s  Countrycode: %s
", $row[0], $row[1]);

		  /* free result set*/
		  $result->close();
	      }

	      /* close connection */
	      $mysqli->close();
	      ?>

       Example #2

	      Procedural style

	      <?php
	      /* Open a connection */
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (!$link) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      $query = "SELECT Name, CountryCode FROM City ORDER BY Name";

	      if ($result = mysqli_query($link, $query)) {

		  /* seek to row no. 400 */
		  mysqli_data_seek($result, 399);

		  /* fetch row */
		  $row = mysqli_fetch_row($result);

		  printf ("City: %s  Countrycode: %s
", $row[0], $row[1]);

		  /* free result set*/
		  mysqli_free_result($result);
	      }

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      City: Benin City	Countrycode: NGA

SEE ALSO
       mysqli_store_result(3),	 mysqli_fetch_row(3),	mysqli_fetch_array(3),	 mysqli_fetch_assoc(3),  mysqli_fetch_object(3),  mysqli_query(3),
       mysqli_num_rows(3).

PHP Documentation Group 												       MYSQLI_DATA_SEEK(3)