hello....
i am fully confussing with this problem. i have to display sorting order from my table. i have table like this.
auto_id,firstname,passportno(int).
now i am displaying
order by passportno
but here i saw very funny issue.
i have passport nos like this.....
077,100,099,088,101,1000.
now after executing the query
"SELECT * FROM passport_registration ORDER BY passportno LIMIT $start , $q_limit"
diaplaying like this.
77,88,99,100,101,1000
even i tested in phpmyadmin also...displaying same. what to do? i want to display 077,088,099 exactly