The14thGOD Posted December 13, 2007 Share Posted December 13, 2007 I'm making a custom back end for a client and currently the way that it is set up is for them to basically make an event. I didn't use an actual date formated date, (ie i used a varchar to store the month as December/November etc etc). Can MySQL organize that by chance ASC and DESC or am I going to have to go back to the actual date field? Thanks Justin Link to comment https://forums.phpfreaks.com/topic/81516-solved-question-about-order-by/ Share on other sites More sharing options...
phpQuestioner Posted December 13, 2007 Share Posted December 13, 2007 yes, because each months text can be ordered. yeah - it will not sort January-December or vise versa; with just the months by them self (without numbers). Link to comment https://forums.phpfreaks.com/topic/81516-solved-question-about-order-by/#findComment-413840 Share on other sites More sharing options...
revraz Posted December 13, 2007 Share Posted December 13, 2007 It will sort it Alphabetically, since it's a varchar. It doesn't know what month is what. You would have to either use a mysql date or a unix timestamp to actually sort by dates. Link to comment https://forums.phpfreaks.com/topic/81516-solved-question-about-order-by/#findComment-413842 Share on other sites More sharing options...
The14thGOD Posted December 13, 2007 Author Share Posted December 13, 2007 ah, figured, thanks for the help. Link to comment https://forums.phpfreaks.com/topic/81516-solved-question-about-order-by/#findComment-413852 Share on other sites More sharing options...
revraz Posted December 13, 2007 Share Posted December 13, 2007 You could always do something like 1. Jan 2. Feb etc Link to comment https://forums.phpfreaks.com/topic/81516-solved-question-about-order-by/#findComment-413856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.