I have an database, and one column will have a number 1-10.

When I shop them ordered by that number, will they propery show

1
2
3
4
5
6
7
8
9
10

or do it wrong, like some things do when alphabetizing:

1
10
2
3
4
5
6
7
8
9

What do you think I should do?

Should i do 0-9?

should they be 01, 02, 03, ect.?

There may be more than 10 later.

It depends upon the coding. You can manage it by using if else statement. If you declare it as a char type, the result: 1, 10, 11, 12 ..... but for numbers, the result: 1,2,3,4......

why don't use 01 02 03 04 05 06 07 08 09 10 etc?
I think that will be working in any case.

IF they are REALLY numbers. It doesn't matter, and they will show in the correct numeric order with or without a leading zero

HOWEVER

If they are strings of number characters you will need a leading zero as then they will be sorted in ASCII value order.

You have to change the field type to Numeric in database. This is resolve the sorting issue when browsing the products on web interface.

If you are using the MS Access database then you will have to change the field type in database and if MS Sql then you can convert the field type in sql query.

If the column type is Numeric(Integer) then it will give you the results as 1,2,3.. etc and If you have column type Text(Varchar) then it will give you the results as 1,10,2,3... etc

Chris Hirst has the right answer. As strings, it goes 1, 2, 20, 25, 3, 35, 4, and so on. If you sort them as numbers, you'll avoid this, and if you must sort them as strings, prefix them to a set width, as 001, 002, 020, and so on.