使用sql：语法错误删除联系人列表中的后续关系？

Question

我试图删除我的数据库中的关系。我想用一个查询执行一个代码，删除我所关注的一个，也是相反的方向。我有下面的代码，有一个语法错误：

//profileId is the current user and contactsProfileId which user he/she follows 
$sql = " 
DELETE FROM contactlists 
WHERE (profileId = '$profileId AND contactsProfileId = '$contactsProfileId') 
OR (profileId = '$contactsProfileId' AND contactsProfileId = '$profileId') 
"; 

Answer 1

你忘了添加关闭'单引号的$profileId。

试试这个

$sql = " 
DELETE FROM contactlists 
WHERE (profileId = '$profileId' AND contactsProfileId = '$contactsProfileId') 
OR (profileId = '$contactsProfileId' AND contactsProfileId = '$profileId') 
"; 

Answer 2

看看第一$profileId：

//profileId is the current user and contactsProfileId which user he/she follows 
$sql = " 
DELETE FROM contactlists 
WHERE (profileId = '$profileId' AND contactsProfileId = '$contactsProfileId') 
OR (profileId = '$contactsProfileId' AND contactsProfileId = '$profileId') 
"