> $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(); Try: $update = "UPDATE accounts SET atime=NOW() WHERE id-sys='$tmp'"; NOW() is a function, don't enclose it within quotes and make it a string. You don't put quotes around column names, either, only string values. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
