[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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
