User-334574633 posted
Hello, i have something like this, i want the annoucements (status = 0) to be on top, then topics with (status = 1) below, then the rest of the topics.
So i tried:
SELECT
forum_topics.id, forum_topics.status,
forum_topics.username
AS starter, forum_topics.subject,
forum_topics.closed, forum_topics.answerpostid,
forum_topics.views, forum_topics.answers,
forum_topics.lastanswer, forum_topics.lastanswerid,
forum_topics.created
AS started, forum_answer.username,
forum_answer.answer, forum_answer.created
FROM forum_topics
LEFT OUTER
JOIN forum_answer
ON forum_answer.id
= forum_topics.lastanswerid
WHERE (boardid
= @ID OR boardid
= 0)
ORDER BY
(status)
ASC,
(created)
ASC
Problem is that they are not sorted diffrently, when i change the (created) ASC to (created) DESC i get the same result and the rows are not sorted, they only get sorted by status so i have status=0 at
the top, then status=1 then the rest. How do i get them to be sorted first by status ASC then by created ASC/DESC?
Patrick
