fantomel Posted January 14, 2010 Share Posted January 14, 2010 Hello can someone please explain to me how to display random records from a db? thank you Link to comment https://forums.phpfreaks.com/topic/188478-select-random-records-from-mysql/ Share on other sites More sharing options...
JAY6390 Posted January 14, 2010 Share Posted January 14, 2010 just add ORDER BY RAND() LIMIT X to the end of your query changing X to the number of records you want Link to comment https://forums.phpfreaks.com/topic/188478-select-random-records-from-mysql/#findComment-995035 Share on other sites More sharing options...
fantomel Posted January 14, 2010 Author Share Posted January 14, 2010 just add ORDER BY RAND() LIMIT X to the end of your query changing X to the number of records you want thanks i`ll give it a try:D Link to comment https://forums.phpfreaks.com/topic/188478-select-random-records-from-mysql/#findComment-995051 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.