newb Posted May 25, 2012 Share Posted May 25, 2012 the results in my query are showign up like this: DP2 DP1 SL2 SL1 1 2 3 .. 10 11 12 how can i get them to show up like this instead: DP1 DP2 SL1 SL2 1 2 3 .. 10 11 12 here's my query: SELECT varname FROM table WHERE cat_id =8 ORDER BY varname+0 ASC any help is appreciated, thanks. Quote Link to comment https://forums.phpfreaks.com/topic/263091-need-help-with-ordering-mysql-query-results/ Share on other sites More sharing options...
newb Posted May 25, 2012 Author Share Posted May 25, 2012 nvmd fixed added ,varname to end of query Quote Link to comment https://forums.phpfreaks.com/topic/263091-need-help-with-ordering-mysql-query-results/#findComment-1348473 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.