Hello,
I need to sort two querys. Like I have a sort by ID but now I need it to be sort by ID and then somethign else. So it puts everything in order by ID and then by the other number.
2 Sort by's
Moderator: General Moderators
- nickman013
- Forum Regular
- Posts: 764
- Joined: Sun Aug 14, 2005 12:02 am
- Location: Long Island, New York
Looks like he's asking how to sort by 2 fields in a query, something like..
Shouldn't be too far off.
Code: Select all
SELECT * FROM `table` WHERE `fieldOne`='this' ORDER BY `fieldTwo`,`fieldThree` ASC;