...

View Full Version : ordering values



jeromepelletier
08-24-2006, 06:30 PM
How do i order numbers retrieved by there value, such as: 1,2,3,4,5...12,13...22 so its like that instead of 1,11,12,13,14,2,21,22,23,24,31,4,5,6...

thankds

guelphdad
08-24-2006, 11:45 PM
you would use an integer (INT) or other numeric type for your data column instead of using a string type like CHAR or VARCHAR which is what you have used.

jeromepelletier
08-27-2006, 04:31 AM
you would use an integer (INT) or other numeric type for your data column instead of using a string type like CHAR or VARCHAR which is what you have used.
using a time but its custom, so i cant use a time field, crap was hoping i could just use some function to put it in order.

guelphdad
08-27-2006, 03:42 PM
if those are TIME values why can't you use TIME to store them in? what is preventing you from doing so?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum