What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

mysql_data_seek
Prev	XLI. MySQL Functions	Next

mysql_data_seek

Name

mysql_data_seek — Jumps to a specific row in a MySQL query result.

Synopsis

bool mysql_data_seek(result_handle, row_number); mysql result result_handle: MySQL result handle returned by mysql_query() or mysql_db_query() int row_number: Target row offset

Returns

TRUE on success; FALSE on error

Description

mysql_data_seek() is used to move the internal pointer in a MySQL query result set to a specific row.

Subsequent calls to any of the functions that fetch a row of data from a query result handle will start at the specified offset. MySQL result handle row offsets start at 0.

Version

PHP 3+, PHP 4+

Example

Example 794. Fetch a random row from a result set

<?php
// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('mysql_connect.inc.php');

// Storing our query in a variable helps us debug more easily
$query = "SELECT * FROM user";

$result = mysql_query ($query)
    or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');

// Find out how many results the query returned
$num_results = mysql_num_rows ($result);

if ($num_results) {
    // Generate a random number between 0 and $num_results - 1
    mt_srand ((double) microtime() * 1000000);
    $rand = mt_rand (0, $num_results-1);

    // Jump to the random row
    mysql_data_seek ($result, $rand);

    // Fetch the selected row
    var_dump (mysql_fetch_object ($result));
}

// Keep in mind that this is a one-line query in MySQL 3.23.3+ :)
// SELECT * FROM user ORDER BY rand() LIMIT 1
?>

Prev	Home	Next
mysql_create_db	Up	mysql_db_query

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.