PHP/mySQL and RANDOM

Morning all

A bit stressed here as I am trying to add a random bit of source but with no look. I have scoured the net and still found northing, so just wondered if any of you intellectual type could point me in the right direction;

OK, I have sql database with a table called ss_offers

Basically I want to randomly select one record from the table and show the fields name, details, date

But how on earth do you do the random selection? Have tried the following with no joy;
$query = "SELECT * FROM ss_offers ORDER BY RANDOM() LIMIT 1";

Hope someone can point me in the right direction before I pull my LAST hair out!

try

$query = "SELECT * FROM ss_offers ORDER BY RAND() LIMIT 0,1";

I think....

bertm - thankyou very much, it worked and I still have my hair left! <img src=http://www.gamers-forums.com/smilies/contrib/ruinkai/biggthumpup.gif ALT=":thumb">

I have a post on another board;
www.phpbuilder.com/board/...d=10237673

Still related to the original request, but it sometimes returns 2 items from 1 section. Any idea how this can be coded aswell?

Frostie - how are you getting on with this? Wasn't too sure what you meant in your last post?

Yes it works a treat now - thanks anyway for checking.