我试图通过比较4个字段和4个变量来更新表上的验证列
下面是示例代码
$query1 = mysql_query("UPDATE tbl_grades_subj
SET activated01 = 1
WHERE grades_subject_code = '$hidden_subj1'
& grades_term = '$hidden_term1'
& section = 'hidden_sec1'
& grades_sy = 'hidden_sy1'")
or die(mysql_error());
语法错误。您需要在WHERE
子句中使用AND
而不是&
。
WHERE grades_subject_code = '$hidden_subj1'
AND grades_term = '$hidden_term1'
AND section = 'hidden_sec1'
AND grades_sy = 'hidden_sy1'
用AND
代替&
。&
是按位与,你需要一个逻辑与
... WHERE field=X and field=Y AND field=z etc...