Menu
Hi There
Ok i have a field in my db called sortid and in there i have data like 002a, 0015z,001a, 0015a, 002b
and they are in no order in the db just random in there
i want to use a select statement and sort it
here is my select statemnt
[code=php]“SELECT * FROM tablename ORDER BY (sortid+0) ASC”
and i get it in this order
001a
002a
002b
0015z
0015a
how do i get it to sort to show
001a
002a
002b
0015a
0015b
HELP ME I’m going crazy LOL?