Grouping mysql rows by type

[dkin]

I can not figure out how to do this, I have used group by and order by and my browser does not respond to it.

I am trying to group items alphabetically by type.

ie

glove
glove
glove
shield
shield
weapon
weapon

Any help?

[jatar_k]

select * from mytable order by type asc

if you are using IE, is it just the dreaded force reload?
use ctrl + F5, forces it to reload as it caches info pretty hard

[dkin]

damm, why didnt that work the first time