Group by? Display problem

[TGixer]

Im trying to get data to display a certain way.

I have 2 tables
user
rank

user(user_id,
user_name,
rank_id)

rank(rank_id
rank_name)

user.rank_id =rank.rank_id

now

i want to query thru and display the info like this

RANK NAME (aaa)
user1
user2

RANK_NAME (bbb)
user3
user4

how can i do this....??

as i do it now, i get this

RANK_NAME(aaa)
user1
user2
user3
user4

nothign else?!?!?!?😕

[dnszero]

I think that what you really want is and ORDER BY and not a GROUP by in your SQL statement.

[TGixer]

i have an order by

but the users need to be grouped under their RANK.

[dnszero]

Grouping is an aggretation operation, it's not designed to
accomplish what you want. Try something like
SELECT user.user_id, user.user_name, rank.rank_name
FROM user, rank
WHERE user.rank_id =rank.rank_id
ORDER BY rank_name, user_name

This will group (in the sense you mean) all of users in each rank together. Then you can just print it out however you like. If that doesn't quite make sense to you, runn that querry by hand and look at the raw output. It should all come together then.