Jump to content


Photo

ORDER BY help *solved*


  • Please log in to reply
No replies to this topic

#1 digitalgod

digitalgod
  • Members
  • PipPipPip
  • Advanced Member
  • 374 posts

Posted 19 October 2006 - 12:42 AM

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  ::)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users