Display Random Data

[Dysan]

Hi, I have a database, containing people's names, ages, and gender's.
How do I randomly display a different persons record, upon refreshing the page?

[Xager]

Get everyone from the DB, generate a random number between 1 and mysql_num_row() on the query and display that user by using mysql_fetch_array()

[kakki]

SELECT
FROM
WHERE 
ORDER BY RAND()

[leatherback]

If you want each record to be shown an equal amount of time: Store the latest record ID shown (e.g., in a temp file) and select the next ID from the database (select .. from TABLE where ID > LAST_ID limit 1.

This will not retrieve a random record from the database, but will for the user create a random records shown, especially if the website gets some visitors simultaniously.