PHP & MySQL dates

[Anon]

I need to retrieve and display a date from mysql in the format d/m/Y, allow users to change the date, then pass it back to the db in the correct format (Y/m/d).

I have tried to split the date var using: split(), explode(), and then making a timestamp using mktime() and finally formatting the date using:

$returndate = date("Y/m/d",$mytimestamp).

However, this does not appear to be giving the correct results.

Can soemone help please.

Craig

[[deleted]]

manuals, manuals and more manuals.

You can get the date in the format you want from MySQL using
the date_format function of mysql.

Putting the date back in would be easy with just the right explode()

$a=explode("/","dd/mm/yyyy");
echo $a[2]."/".$a[1]."/".$a[0];