[SOLVED] ORDER BY

[mcmuney]

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?

[Maknis]

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?

[mcmuney]

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?

[PFMaBiSmAd]

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().

[Maknis]

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().