> I am attempting to UPDATE a table and I have having absolutely ZERO
> success.  Here is the query:
> $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> $update = "UPDATE accounts SET atime='NOW()' WHERE
> \"id-sys\"='".$tmp."'";
> echo $update;
> $result1 = mysql_query($update, $Prod) or die(mysql_error());
> echo mysql_affected_rows();
> Please help me figure out why this is not working.  I have tried
> quoting the column name 'id-sys' every way I can think of, but nothing
> works.  The column is initially NULL, and I am attempting to update just
> single column with a timestamp.  Thanks in advance.

NOW() is a function and should not be part of a quoted string.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to