mcmuney Posted August 5, 2009 Share Posted August 5, 2009 I rand a query and pulled the last 25 members who signed on, the end of the query looks like this: ... ORDER BY signed_on_time DESC LIMIT 0,25; But what I'd like to do is take the 25 results and display them in random order, how can I do that? Quote Link to comment Share on other sites More sharing options...
Maknis Posted August 5, 2009 Share Posted August 5, 2009 something like ORDER BY RAND() LIMIT 0,25; I rand a query and pulled the last 25 members who signed on, the end of the query looks like this: ... ORDER BY signed_on_time DESC LIMIT 0,25; But what I'd like to do is take the 25 results and display them in random order, how can I do that? Quote Link to comment Share on other sites More sharing options...
mcmuney Posted August 5, 2009 Author Share Posted August 5, 2009 No, I just can't do a ORDER BY RAND(). By doing that, it will not show the last 25 users who logged in, but take any random 25 users. First, I need to take the 25 users who has logged in last by using ORDER BY signed_on_time DESC, I then need to do a second ORDER BY. Does that make sense? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted August 5, 2009 Share Posted August 5, 2009 You can use the method found in this post - http://www.phpfreaks.com/forums/index.php/topic,262605.msg1237786.html#msg1237786 The subquery returns the rows you are interested in. The main query would order those rows using rand(). Quote Link to comment Share on other sites More sharing options...
Maknis Posted August 5, 2009 Share Posted August 5, 2009 Would a Shuffle($array); work as well? You can use the method found in this post - http://www.phpfreaks.com/forums/index.php/topic,262605.msg1237786.html#msg1237786 The subquery returns the rows you are interested in. The main query would order those rows using rand(). Quote Link to comment 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.