Sorting in descending order

[taz321]

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

[discomatt]

Are you grabbing them via mysql? If so, add DESC to your order by clause.

 

SELECT * FROM `table` ORDER BY `id` DESC

[Orio]

SELECT * FROM `messages` ORDER BY date DESC

 

Orio.

[discomatt]

SELECT * FROM `messages` ORDER BY date DESC

 

Orio.

 

Just so you know, he said newest queries, not queries with the latest date

[taz321]

Thanks, all working now.