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 Quote Link to comment 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). Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
The14thGOD Posted December 13, 2007 Author Share Posted December 13, 2007 ah, figured, thanks for the help. Quote Link to comment 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 Quote Link to comment 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.