Senthilkumar Posted February 16, 2023 Share Posted February 16, 2023 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 Quote Link to comment https://forums.phpfreaks.com/topic/315921-query-fro-short-number-lower-to-higher/ Share on other sites More sharing options...
requinix Posted February 16, 2023 Share Posted February 16, 2023 Your BPosition is a string field. If it has numbers then it should be a numeric field. Quote Link to comment https://forums.phpfreaks.com/topic/315921-query-fro-short-number-lower-to-higher/#findComment-1605757 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.