Randomising output from database

[Anon]

Can anyone show me or point me in the correct direction for information regarding randomising my output from the database.

example: people enter there names into my database. But I want the output from the database to be different every time I visit the page so that everyone gets a fair share of being at the top of the list.

[mmilano]

$result=mysql_query("select * from users order by rand()");

i think this should work =)