Sorting database by ID number issues

[akido]

Pretty simple:

Query:
SELECT * FROM links WHERE category = '$page[link]' ORDER BY id"

ID is a numerical sequence:
--id|title|url|category--
1|Link Title|Link URL|Category
2|Link Title|Link URL|Category

However, when the ID goes above 9, it sorts the database like so:
1|Link Title|Link URL|Category
10|Link Title|Link URL|Category
2|Link Title|Link URL|Category

Any way to make MySQL sort numbers in a proper numerical order?

[siwis]

What is the field type of your field id?

sounds like you've not got an integer type in use as it is being sorted alphanumerically.

ALTER TABLE name CHANGE id id INT (6) not null AUTO_INCREMENT

[akido]

Oh thanks a ton. That fixed it.