Order by date

[marcebra]

hello,

I am wondering if there is a way to order a list of items being downloaded from a php database by date.

I have a database with dates (ie September 25, December 2). But it is annoying to be putting them in order into the database. Is there a way I don't need to keep on putting them in order into my database and only when i call them, they will be put in order? Right now i only have dates in 2003, but in a month or two, I will start to put '04 dates. I was thinking that perhaps I could write out the dates in numerical format and have it order by the year, then the month and then the date.

I would rather have a way to do it with a written date, but I can accept a numerical date ordering script.

Thanks in advance

[planetsim]

When i use dates i usually get the time(); function to do it

Then order it by the time which is INT(11) in the database.

From there just use the date function

date("format here","timecodehere");
to display the Date. A lot easier. Then having dates in text format.