Re: Sorting and Grouping with two different fields

Notice that if id field is 'auto_increment' you cannot have two 7s. Also, it's better to use SQL on your data as they might increase in uncontrollable way. That's what the databases are for in the first place.
For your data you can use SQL like this (MySQL): ORDER BY state DESC, id ASC
Implementing this in Perl would be a waste of time, as the database can do it for you already.

Comment on Re: Sorting and Grouping with two different fields Download Code

Replies are listed 'Best First'.
Re^2: Sorting and Grouping with two different fields by atemon (Chaplain) on Jul 12, 2007 at 12:48 UTC
I can not use "`OREDR BY state DESC`" so that Virginia will come up. When I sort by state with " `DESC state, id ASC`" the order of states will be "Washington, Virginia,Indiana". But I need it sorted by id, but grouped with state. --VC	[reply] [d/l] [select]
Re^3: Sorting and Grouping with two different fields by Tobin Cataldo (Monk) on Jul 12, 2007 at 13:48 UTC
I would just add another field SMALLINT from 1-50 called sort_order and then you can apply your arbitrary sort order to each state... `UPDATE table1 SET sort_order = 1 WHERE state = "Virginia"` [download] Then you can `ORDER BY sort_order DESC, city DESC` [download]	[reply] [d/l] [select]
Re^4: Sorting and Grouping with two different fields by atemon (Chaplain) on Jul 12, 2007 at 14:52 UTC
Your answer is too specific. If its dealing with only 50 states of US, Its OK to assign 1-50 called sort order. Here I am NOT allowed to alter the structure of the table as there are many other programs that depends on no of columns and other structure of the table. I am NOT allowed to add any temperory table. We wont mind the overhead caused by the sort algorith implemented. What I am looking for is a logic like Limbic~Region suggested.	[reply]