 |  |  |  |  |  |  |  |
Date Field in MySQL with PHP /add/edit/delete
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
•
•
Join Date: Aug 2005
Posts: 5,266
Reputation: 
Solved Threads: 377
Are you inserting the dates using single quotes? Dates in mysql go yyyymmdd.
I.e '2006-01-02'
I.e '2006-01-02'
Last edited by iamthwee; Jun 25th, 2007 at 2:45 pm.
*Voted best profile in the world*
•
•
Join Date: Jul 2004
Posts: 494
Reputation:
Solved Threads: 21
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.)
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.)
www.uncreativelabs.net
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
my problem is with adding and updates.
can anybody give me any example. with any drop down date selectror.??
thnx
can anybody give me any example. with any drop down date selectror.??
thnx
•
•
Join Date: Aug 2005
Posts: 5,266
Reputation:
Solved Threads: 377
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.
Then echo it out. If all that's ok then its look at your php for the problems.
Last edited by iamthwee; Jun 26th, 2007 at 3:10 pm.
*Voted best profile in the world*
|
Similar Threads
- three dimensional arrays (PHP)
Other Threads in the PHP Forum
- Previous Thread: CMS - I don't quite get it???
- Next Thread: Sessions
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array beginner beneath binary broadband broken button cakephp checkbox class cms code countingeverycharactersfromastring crack cron curl database date display dynamic echo email error fcc file files folder form forms freelancing function functions google href htaccess html image include incode insert integration ip javascript joomla limit link login mail match menu method mlm mod_rewrite multiple mysql oop pageing pagerank paypal pdf php problem query radio random recursion recursiveloop remote script search server sessions sms smtp soap source space sql strip_tags subversion support! survey syntax system table template tutorial undefined update upload url validator variable video virus web window.onbeforeunload=closeme; youtube
