ORDER BY SCORE AND RANDOM

[jwwceo]

Hello,

 

I have a query that organizes shirts by a set of criteria which changes based on what the customer clicks, either by score, alphabetical, date, etc.

 

This works great. But if I have the shirts organized by score and lots of shirts have the same score, then it just seems to pull from the database in the order they were inserted, or by shirt_id. I would like to have some randomness insterted, so any shirt with the highest score, 1 can show up first. So basically, order first by my criteria, and then within that, by randomness. Here is my query so far:

 

 

 

$data = mysql_query("SELECT * FROM shirts WHERE active='true' AND approved='1' ORDER BY $field $direction LIMIT $from, $max_results") or die(mysql_error());

 

[GingerRobot]

Well, you can order by RAND(), so if you add this as the second field to order by, it should work ok:

 

$data = mysql_query("SELECT * FROM shirts WHERE active='true' AND approved='1' ORDER BY $field $direction, RAND() LIMIT $from, $max_results") or die(mysql_error());