Updating/Adding A Date
Posted: Sat Mar 11, 2006 12:15 pm
Updating or Adding dates to my database is not working.
Fields:
id INT(11)
date_ordered DATE (default 0000-00-00)
Same with my insert query:
Fields:
id INT(11)
date_ordered DATE (default 0000-00-00)
Code: Select all
mysql_query("UPDATE cases SET date_ordered='2006-03-11' WHERE id='1'");Code: Select all
mysql_query("INSERT INTO cases SET date_ordered='2006-03-11'");