[RESOLVED] Getting results in a certain order?

[slick101]

Hey everyone,

I have a table named user and it consist of a field named admin.

Im showing a display of users on a certain page and would like to have admins always as the first results so if I have 2 admins in the database the first 2 rows will be admins.

Is there a way to do this? Does this have something to do with GROUP BY?

Thank you for the help!

[Weedpacket]

ORDER BY however it is that you indicate that a user is an admin.

[slick101]

haha yes thank you weedpacket...damn I dont know how I forgot that I guess was thinking a little more. Many thanks!