note 43570 deleted from function.mysql-data-seek by tomsommer
| From: | tomsommer@php.net | Date: | Sun, 27 Jun 2004 00:58:37 +0000 |
| Subject: | note 43570 deleted from function.mysql-data-seek by tomsommer | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-71835@lists.php.net to get a copy of this message | ||
Note Submitter: nospam@jwd.dds.nl
----
An example how to display a random record from the result set using mysql_data_seek:
<?php
mysql_select_db($database, etc);
$query_query = "SELECT * FROM table";
$result = mysql_query($query_query, $database) or die(mysql_error());
$totalRows_result = mysql_num_rows($result);
mysql_data_seek($result , rand(0,$totalRows_result));
$row_result = mysql_fetch_assoc($result);
?>