Re: [PHP] random record?

[David Otton]

On Thu, 20 Sep 2001 10:35:59 -0400, you wrote:

>i'm looking to select a random record from a sql table.  I remember seeing 
>code for it on the list but fail to find it now.  any help?

SELECT columns FROM table ORDER BY RAND() LIMIT 1

djo


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]