Ok, here's what i got in my mysql db. I got a table listed with numbers as
follows
1
2
3
4
5
6
7
10
11
12
13
14
15
16
17
18
19
20
21
22
25
These numbers I can display fine. I'm using ..
$query=SELECT * FROM db ORDER BY numbers ASC;
Right now it displays it as
1
10
11
12
.
2
22
23
25
are they defined as integer or varchars (string)?
try
a) exchange field definition varchar / integer
b) order by length(number) and later by number
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
if you have these as strings, I would recommend a column data type
conversion to int(or other numeric as the case may be)failing that I
would use the CAST command to convert the data to numerics
see here
http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html
to use
select