PHP Putting a date back into MySql

Hi

I am a newbee. using Dreamweaver MX - PHP and MySql Database

I have an Insert record form with a date_submitted field.
When I submit a date "07/07/04" or "07/07/2004" it works ok but the date
stored is not correct.

When I display a date, I searched and found an example for the Date text box.
echo date("dS M Y",strtotime($row_news_rs['Submit_date'])); = "07th July 2004"

But when I save a record the date stored is not correct.

I did search again but but with no luck

Thanks in advance

PHP uses the date format yyyy-mm-dd, so you need to convert the date to this
format before you insert it into a MySQL date field.


--
Gareth
http://www.garethdp.com/
Buzz inet - http://www.buzzinet.co.uk/

Team Macromedia Volunteer for Dreamweaver MX
Dreamweaver MX Support: http://www.dreamweavermxsupport.com/index.php

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
http://www.dreamweavermxsupport.com/extensions/

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox

Thanks for your quick reply

David