Outputting random entries from table

[LukeO]

Hey,

I have a table, with 3 fields, Name, SubmissionText and Email.

What I need to do is create a script which will take 100 random entries and show them to me.

Any ideas?

Thank you all in advance,

Luke

[nnichols]

Try the following SQL statement -

SELECT * 
FROM tbl_name
ORDER BY RAND()
LIMIT 100

Hope this helps 😉