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



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


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


TRUE on success; FALSE on error


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.


PHP 3+, PHP 4+

See also

To retrieve rows of data from a MySQL result handle:






Example 794. Fetch a random row from a result set

// 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 ('');

// 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

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 The authors of this book have elected not to choose any options under the OPL. This online book was obtained from 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.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.