$results = mysql_query('SELECT * FROM members WHERE category1="Photographers" ORDER BY premium DESC, featured DESC, company ASC');
Everything works great, Premium members show up above featured. Featured above regular members, and they are all in alphabetical order. However I want to have featured members randomized and not in alphabetical order. I have tried RAND() but it randomizes all my members, please help.
3 Months Ago
Related Article:SQL - Group By unique column combination
is a solved Databases discussion thread by PhilEaton that has 1 reply, was last updated 10 months ago and has been tagged with the keywords: sql, group, by, combination.