SQL Query problem

[xyn]

Hey,
I have a case script in SQL so that NEW private Messages
are always ordered at the top, then everything else which is
read are listed under-neath, but the problem with this is
everything is NOT in date order, which is confusing me...
I basically wanted new messages at the top in order of
DATE descending. but everything else under that is randomly
ordered...

my code:
SELECT id,fr_usr,subject,stats,date,time,
CASE WHEN stats='3' THEN 1 WHEN stats='0' THEN 2 ELSE 3 END as pmsort
FROM pm
WHERE to_usr='{$_SESSION['username']['usr_user']}'
ORDER BY pmsort,date DESC

Any ideas?

[fenway]

Well, it won't be in date order, since date is your second order by criterion.