Having a problem with sorting in mysql the following select sorts the lastupdate column correctly, but sorts the sticky wrong if i reverse "order by lastupdate,sticky" the sticky column is sorted correctly but lastupdate is wrong.
SELECT * FROM tblforumthreads t order by sticky,lastupdate desc
How do i get it to sort by sticky, then by the lastest dates?