Posted by hamstring on 10/14/43 11:26

Is it possible to 'order by' 2 columns in a database

My database only has 2 columns.
1st column a bit of text
2nd column a int number
typically

COL1 COL2
AB 2
AZ 5
AF 1
AA 7
BC 5
AD 5

I want it sorted to
COL1 COL2
AA 7
AD 5
AZ 5
BC 5
AB 2
AF 1

Any ideas, as I can pnly get 1 column sorted ??

• Next in forum: Re: Order By - problem
• Prev in forum: Mysql_query() only allows one SQL query at a time. Other options?
• Thread view: Order By - problem

[Reply to this message]