PHP and dates and times etc...

[prock]

I am sure I'm not the only person facing this problem.

To summarize:

My client is a speaker and he needs to put his itenerary up on the web.

So he enters his Itenerary into a form and the dates are entered like so (as text) mm/dd/yy/.

I convert that to a Unix timestamp using strtotime().

That gets stored in a mySQL db.

Now my question is how do I pull that back out, parse it back to english, and sort his Itenerary to show all future speaking dates from today?

I know how to do this in ASP but for some reason I am totally cluster confused as I read the docs on this in mySQL and PHP.

Any help/Advice would be appreciated.

Thanks
Pat

[saquib]

Once you pull out the unix time stamp from the database using an SQL query... try the following

suppose your unix time stamp is in $timestamp;

date("d M Y",$timestamp);

this will produce date in the format 11 Sep 2002

Hope this helps

Saquib