hi,

I was wondering if it's possible to select a random record from a table in a mysql database.

i've read the php.net manual, and below is the code that they suggested:
Code:
SELECT * FROM table ORDER BY RAND() LIMIT 0,1
but it doesn't seem to work.

can somebody help?

Thank you