ORDER BY two fields?

jonno946

I am making a basic forum system.

The topics are ordered by timestamp ($date) DESC, so the newest posts appear first in the list.

However, i want to add a 'sticky' feature to the site, where as i can put admin messages that are permanently at the top of the post lists.

I have done this by creating an field in my mysql database called 'sticky' - this is either a 0 (no sticky) and 1 (sticky).

So, ive throught the easyest way to order the topics now is to order by 2 fields, 'sticky' (ASC) and 'time' (DESC).

How can i do this?

My current query is below:

SELECT * FROM posts WHERE forumid = '$cat_id' AND replyid = '' ORDER BY date DESC

Many Thanks!

Jonathan

leatherback

Hi,

I am not sure wether you can actually do that in mysql (don't think so though).

What you very easily could do..

Whne you get your results, you check fo rthe col sticky, and fill two var's with the output:

while($row = mysql_fetch_array($results))
  {
  if($row[sticky] == 1)
    {
     $stickyout = "some output";
    }
  else
    {
    $nonsticky = "someoutput";
    }
  }

echo $stickyout . $nonsticky;

LordShryku

Considering you'll want the sticky at the top, you should do stick DESC, but you just comma seperate your order by's

  SELECT * 
    FROM posts 
   WHERE forumid = '$cat_id' 
     AND replyid = '' 
ORDER BY sticky DESC, date DESC

jonno946

LordShryku's solution works great 🙂

Thanks guys.