Re: Picking a random record from a database.
| From: | Tyler Longren | Date: | Tue, 05 Feb 2002 04:44:13 +0000 |
| Subject: | Re: Picking a random record from a database. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-83518@lists.php.net to get a copy of this message | ||
SELECT * FROM table ORDER BY rand() LIMIT 1;
Tyler
----- Original Message -----
From: "Philip J. Newman" <newmanpj@philipsdomain.com>
To: <php-general@lists.php.net>
Sent: Monday, February 04, 2002 10:37 PM
Subject: [PHP] Picking a random record from a database.
I have a database of Jokes.
I have 30 Jokes
I would like (each time the page is loaded) to have a random Joke appear.
Can anyone help.
Philip J. Newman
Philip's Domain - Internet Project.
http://www.philipsdomain.com/
info@philipsdomain.com