PHP DATE ORDERING HELP

[kamal213]

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 

[WebStyles]

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

[kamal213]

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

[WebStyles]

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

[kamal213]

Kool will giv it a try.

 

Hav a nice weekend