I have a list of events that's listed by date, I'm also trying to sort it by "featured" so if an event is featured it will be displayed before any other event.
Here's the query I have so far
mysql_query("SELECT * FROM events WHERE CURDATE() <= date ORDER BY featured DESC,date") or die(mysql_error());
but that's still sorting them by date and whether an event is featured or not it doesn't seem to be changing anything.
the values for "featured" are either "yes" or "no"
I'm going to try a few different queries in phpmyadmin but if someone has a solution it would be much appreciated
nevermind it worked, was just changing it at the wrong place
ORDER BY help *solved*
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users