Jump to content

Archived

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

digitalgod

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

*edit*
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.