Adding Records at Start

[Mark Maslowski]

Can someone explain why my SQL query is not working properly?

SELECT DISTINCT level_1 FROM resources ORDER BY ID
should result in a unique list sorted by ID number. Instead I get a list of
everything in a strange order -

["Screenshots Library", "Offline Materials - PDFs", "Websites",
"PowerPoints", "Videos", "Screenshots Library", "Screenshots Library",
"Screenshots Library", "Screenshots Library", "Screenshots Library",
"Screenshots Library", "Screenshots Library", "Pictures Library"]

which when looked at by ID number is
[1, 10, 11, 12, 13, 2, 3, 4, 5, 6, 7, 8, 9]

Personally, I've always thought that 2 came before 10 but I might have been
mistaken.

Any idea what I'm doing wrong?

- M



*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Mark D. Maslowski
Partner/Designer/Programmer

MAJICo - The Mark and June Interactive Company
Serving Northern California - from Napa to Monterey!
www.majico.com

831-336-3343 voice       831-336-3353 fax

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*