Forum Moderators: coopster

Message Too Old, No Replies

Grouping mysql rows by type

         

dkin

9:36 pm on Jan 6, 2005 (gmt 0)

10+ Year Member



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

9:56 pm on Jan 6, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



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

12:21 am on Jan 7, 2005 (gmt 0)

10+ Year Member



damm, why didnt that work the first time