FW: [PHP] random data from mysql db
| From: | Richard Black | Date: | Mon, 05 Aug 2002 08:33:23 +0000 |
| Subject: | FW: [PHP] random data from mysql db | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-111187@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: Richard Black [mailto:rblack@datavisibility.co.uk]
Sent: 05 August 2002 09:33
To: 'tux'
Subject: RE: [PHP] random data from mysql db
SELECT field1, field2
FROM table
ORDER BY RAND()
LIMIT 1
-----Original Message-----
From: tux [mailto:tuxen@gimped.net]
Sent: 05 August 2002 23:28
To: php-general@lists.php.net
Subject: [PHP] random data from mysql db
hey guys,
what im trying to do is display a random entry from a mysql db, is there
a function for this? or do i just have to generate a random number and
go from there?
jo
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php