serious1234 Posted August 5, 2009 Share Posted August 5, 2009 i have a database that has questions and i want to make random of 20 questions of these but in condition that it must be unique and i don't want the same result to show up again or more than once.what is the best way to do that. Link to comment https://forums.phpfreaks.com/topic/169014-unique-mysql-results/ Share on other sites More sharing options...
Maq Posted August 5, 2009 Share Posted August 5, 2009 By using DISTINCT, RAND(), and LIMIT. There are plenty of examples on phpfreaks and the net. Link to comment https://forums.phpfreaks.com/topic/169014-unique-mysql-results/#findComment-891744 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.