Jump to content


This topic is now archived and is closed to further replies.


ORDER BY help *solved*

Recommended Posts

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

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

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.