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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/169014-unique-mysql-results/#findComment-891744 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.