Date Field in MySQL with PHP /add/edit/delete

[gllanci]

Hello

Im makineg a small cms for my purposes and my problem is updating adding dhe DATE, im getting 00.00.0000

can anybody help me making a drop down date with dd/mm/YYYY so I can add - edit ??

Thnx a lot
Enjoy Life

[iamthwee]

Are you inserting the dates using single quotes? Dates in mysql go yyyymmdd.

I.e '2006-01-02'

[Puckdropper]

See also:
http://www.daniweb.com/forums/thread81362.html

http://www.php.net/manual/en/function.date.php

The link to php.net is probably the more useful one for your situation. If you look in the comments, there's a snippet that shows how to format the date and time to MySQL's liking. (It works well, I've used it extensively.)

[gllanci]

my problem is with adding and updates.

can anybody give me any example. with any drop down date selectror.??

thnx

[iamthwee]

The best way to test if you're adding dates correctly is to open up mysql and do it from there, at the command prompt.

Then echo it out. If all that's ok then its look at your php for the problems.