Need help with a query

Anon

Here what I need to do. I select members in my table and I order them by "joindate" witch is the unix time they join. Some of my user are premium user and they should be display first so premium user have another field call "premium" also unix time. Non premium user have the field "premium" = 0. So my question is how do I select them and order them this way

1- all the premium user order by joindate
2- then the rest of the user order by joindate

I would like to do this in one operation of course

I hope you guys understand what I mean, thanks for your reply

Anon

Something similar to this should work in your query...

ORDER BY premium DESC, joindate DESC

That way it would first sort by the premium date, and then if any of the premium dates were the same (like the 0) then it would sort by the joindate.

Anon

Add this to the end of your query.

Order By premium DESC, joindate

Anon

Ok, but the problem is that I don't want the premium user order by their premium date, I want them order by the joindate also. The goal is to display premium user first but they have to be order by joindate also, is this possible? thanks

Anon

2 posibilities.

Are you using the date in the premium field? If not, make it a boolean and then when you sort, all premium would be the same to and the sort would go on joindate.

If you are using the date in the premium field, the other solution I think is a UNION or a JOIN. Basically 2 queries that get put together one after the other. I haven't done much with it, but I think the syntax would be something like....

SELECT
FROM table
WHERE premium <> 0
ORDER BY joindate
UNION
SELECT
FROM table
WHERE premium = 0
ORDER BY joindate

I know syntax is not correct, but the idea is there.

Anon

Ok thanks, that what I want to do!