RE: [PHP] Setting date fields in mysql queries

[snip] 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? [/snip] Are you actually running the query somehow? Like with mysql_query()? Since you didn't deliver more code it this is the guess I would take. $query = "UPDATE countertable SET CurrDate = '$ndate' WHERE ID = $id" ; // do some error checking if(!($data = mysql_query($query, $your_bd_connection))){ print("MySQL reports: " . mysql_error() . "\n"); exit(); } HTH! Jay