ORDER BY help *solved*

[digitalgod]

hey guys,

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

*edit*
nevermind it worked, was just changing it at the wrong place  ::)