> 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

Reply via email to