Setting date fields in mysql queries

From: Date: Wed, 02 Oct 2002 19:16:57 +0000
Subject: Setting date fields in mysql queries
Groups: php.general 
Request: Send a blank email to php-general+get-118637@lists.php.net to get a copy of this message
I have the following line in a program I'm working on: $query = "UPDATE countertable SET CurrDate = '$ndate' WHERE ID = $id" $ndate is a properly formated date read from a text field on a form on the previous page. When I run the query using mysql_query, it returns TRUE each time, but the field is not updated. The only explanation I can think of is that there is something wrong with the date value. I've echoed it to the screen and it looks fine, but the query still doesn't work. Any suggestions? Thanks in advance, Brad

« previous php.general (#118637) next »