taz321 Posted March 11, 2008 Share Posted March 11, 2008 Basically i have an helpdesk system and everytime an user fills in and submits a query, it goes to a work queue. When you look at this work queue - 1) Any new queries are placed at the bottom of the queue instead of at the top, which i want !!, it is much like the phpFreaks forum where all new posts are inserted at the top. Any idea on how to do this Thanks Quote Link to comment Share on other sites More sharing options...
discomatt Posted March 11, 2008 Share Posted March 11, 2008 Are you grabbing them via mysql? If so, add DESC to your order by clause. SELECT * FROM `table` ORDER BY `id` DESC Quote Link to comment Share on other sites More sharing options...
Orio Posted March 11, 2008 Share Posted March 11, 2008 SELECT * FROM `messages` ORDER BY date DESC Orio. Quote Link to comment Share on other sites More sharing options...
discomatt Posted March 11, 2008 Share Posted March 11, 2008 SELECT * FROM `messages` ORDER BY date DESC Orio. Just so you know, he said newest queries, not queries with the latest date Quote Link to comment Share on other sites More sharing options...
taz321 Posted March 11, 2008 Author Share Posted March 11, 2008 Thanks, all working now. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.