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
gllanci 0 Newbie Poster
iamthwee
Are you inserting the dates using single quotes? Dates in mysql go yyyymmdd.
I.e '2006-01-02'
Puckdropper 7 Posting Pro in Training
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 0 Newbie Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.