Order by... yet still group somehow?

[Lashiec]

I have a table, it has users in it, a column named admin and the value for each user is either Y or N. What I wanted to do was have one query that would take all the information I needed and put it into one array based on the users being admins (Y) and at the same time take all the other users (N) and put them in another array...

 

Something like:

 

(admin = Y)

[.0] -> [.0] -> user 1

        [1] -> user 2

        [2] -> user 3

(admin = N)

[1] -> [.0] -> user 4

        [1] -> user 5

 

So that when I get the data back from the database I can loop through all the admins and put them in one list and then loop through all the non-admins and put them in a list. Currently I just do a query, order it by admin, then take the entire return and run it through a loop and checks if each user is an admin or not and puts them into appropriate arrays according to that.

 

It's not a problem really, I only have a few users for each installation of this program, but I was wondering if there was a more advanced / better way of obtaining the same results straight from the database.

[Mchl]

None that I'm aware of. MySQL returns a resultset being just a bunch of rows. If you need a multidimensional array you have to create it by yourself (just like you do now)