MySQL错误:UPDATE和LIMIT的用法不正确

问题描述

如何纠正此问题，以便我的MySQL代码正常工作.

How can I correct this problem so that my MySQL code works correctly.

这是我的MySQL代码，给我带来了问题.

Here is my MySQL code that gives me the problem.

$q = "UPDATE users INNER JOIN contact_info ON contact_info.user_id = users.user_id SET active.users = NULL WHERE (email.contact_info = '" . mysqli_real_escape_string($mysqli, $x) . "' AND active.users = '" . mysqli_real_escape_string($mysqli, $y) . "') LIMIT 1";
$r = mysqli_query ($mysqli, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($mysqli));

推荐答案

根据更新:

这篇关于MySQL错误:UPDATE和LIMIT的用法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！