I have 100+ chalets in a mysql database. The cabin names are numbers (ie. 2,3,7,20,110,218,34,337)
When I do a SELECT * FROM cabininfo ORDER by CABINNAME I get the following results:
110,2,20,218,3,34,337,7
I know that this is a correctly ordered list. How would I change my query to make the results like everyone expects them to be (ie: 2,3,7,20,34,110,218,337)?
Thanks for any help. I just can't figure out how exactly to do this.
Ray
When I do a SELECT * FROM cabininfo ORDER by CABINNAME I get the following results:
110,2,20,218,3,34,337,7
I know that this is a correctly ordered list. How would I change my query to make the results like everyone expects them to be (ie: 2,3,7,20,34,110,218,337)?
Thanks for any help. I just can't figure out how exactly to do this.
Ray