How to display random record with PHP AND MYSQL? Leave a reply Here is very simple way to display random records from MYSQL using PHP. SELECT * FROM TableName ORDER BY RAND() LIMIT 0,1