query fro short number lower to higher

[Senthilkumar]

Dear Team,

 

For my table display, I'm making a php mysqli query that turns short lower numbers to greater numbers. I am using the following query

$qryStr= "SELECT * FROM mark WHERE Branch = '$Branch'  ORDER BY BPosition ASC";

In my table, i am getting the following output on column Branch Position

But I want the output should be display like 1,2,3,4,5,6,7,8,9,10,11,12,13,14 etc...

Can anyone correct my query

[requinix]

Your BPosition is a string field. If it has numbers then it should be a numeric field.