kamal213 Posted September 2, 2011 Share Posted September 2, 2011 Hi Guys, I am to ordering list things by date from my database i.e. from 01/08/2011 to 31/08/2011. I now have dates which are next years date such as 05/01/2012 and 09/01/2011 and this is causing problems it doesnt order correctly. The date 05/01/2012 come right after 04/08/2011 and 09/01/2012 comes right after 08/08/2011 which is not what I want it to do. Is there any way I can put the dates in the proper order so the dates for next year appear mixed up with these years dates. Thanks Quote Link to comment Share on other sites More sharing options...
WebStyles Posted September 2, 2011 Share Posted September 2, 2011 I'm betting you're using a text field (or a varchar) to store the dates... you should be using the date type, which will have this format: YYYY-MM-DD Quote Link to comment Share on other sites More sharing options...
kamal213 Posted September 2, 2011 Author Share Posted September 2, 2011 Hi WebStyles, How have u been longtime no speak lol. Just change in the database from varchar to date. I have tried to post 02/09/2011 to the database but the date comes up as 0000-00-00. Do I also have to change the format of my php script as well? was kinda hoping I wouldnt have to do that Quote Link to comment Share on other sites More sharing options...
WebStyles Posted September 2, 2011 Share Posted September 2, 2011 Hi kamal213 Use something like: date("Y-m-d",strtorime($yourDate)); to convert before inserting in database, and date("m/d/Y",strtorime($yourDate)); to convert to your original format when displaying You can check out all the options here: date Quote Link to comment Share on other sites More sharing options...
kamal213 Posted September 2, 2011 Author Share Posted September 2, 2011 Kool will giv it a try. Hav a nice weekend 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.