title: php mysql forum app...how to make sticky threads?
body: <p>I am working on a mysql/php forum app as part of a corporate intranet system. My problem is that while listing all threads under a particular forum, there could be more than one "sticky threads" which should show on top and the rest should after them sorted by date in descending order.
  Just need to get an idea about the sql query to use. The tables are usual like 
  1. forums (with parent child relation to keep category and forums in one table only)
  2. forum threads
  3. thread replies</p>
  
  <p>Thanks in advance for your help.</p>