> From: Brad Harriger [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 3:17 PM > Subject: [PHP] Setting date fields in mysql queries > > > 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?
When you say it looks fine, are you meaning it looks like 2002-10-02? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php