[Resolved] Random Function

[nick2005]

Hi,

I wonder if anyone can help, I want to create a random function on the site, which selects a random row and displays data from that row.

Sure this is relatively simple, but I'm new to mysql so don't know how to do it.

Any help is appreciated.

[devinemke]

SELECT * FROM table ORDER BY RAND()

[nick2005]

Thanks for your help.