Random Row...
| From: | Brian McGarvie | Date: | Thu, 16 Jan 2003 09:37:34 +0000 |
| Subject: | Random Row... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131833@lists.php.net to get a copy of this message | ||
$sql = "
select count(*) as theCount
from myTable
";
...
$row_id = rand(1, $myrow["theCount"]);
...
$sql_randow_row "
select *
from myTable
where id = $row_id
";
I assume I'm right with the method above to select a random row? or any
other way?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.438 / Virus Database: 246 - Release Date: 08/01/03