newb Posted July 11, 2010 Share Posted July 11, 2010 ok i have a number problem its probably an easy fix but idk i have rows in my database that are like this: A Thread Title 1: New A Thread Title 10: New A Thread Title 11: New A Thread Title 12: New A Thread Title 13: New A Thread Title 2: New A Thread Title 21: New A Thread Title 22: New A Thread Title 3: New I'd likke them to be like this: A Thread Title 1: New A Thread Title 2: New A Thread Title 3: New A Thread Title 10: New A Thread Title 11: New etc etc.. how can i fix? Quote Link to comment https://forums.phpfreaks.com/topic/207443-mysql-number-problem/ Share on other sites More sharing options...
wildteen88 Posted July 11, 2010 Share Posted July 11, 2010 A bit more information is required, such as your table structure and what is 'Thread TitleXX: New' etc. The more information your provide the better the answer you're going to get. Quote Link to comment https://forums.phpfreaks.com/topic/207443-mysql-number-problem/#findComment-1084546 Share on other sites More sharing options...
.josh Posted July 11, 2010 Share Posted July 11, 2010 ideally you would have a column with just the actual thread title, a separate column for an id and another separate column or even whole separate table for that "new", depending on what exactly that is supposed to signify. Then you could just order by id. IOW I sure hope that you don't have 1 column with that whole string as values... Quote Link to comment https://forums.phpfreaks.com/topic/207443-mysql-number-problem/#findComment-1084547 Share on other sites More sharing options...
Pikachu2000 Posted July 11, 2010 Share Posted July 11, 2010 The short answer is, no. You can't get string results from a MySQL query sorted in a natural order. And ditto to what wildteen88 and CV said. Quote Link to comment https://forums.phpfreaks.com/topic/207443-mysql-number-problem/#findComment-1084556 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.