Jump to content

ORDER BY help *solved*


digitalgod

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  ::)
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.