php - SQL : Unknown column in 'where clause'

Question

我有一个代码:

$id=implode(",",$selected);

$query = "SELECT u.id, p.brand, n.number FROM `user` u 
LEFT OUTER JOIN `phone` p ON u.id = p.id LEFT OUTER JOIN `number` n 
ON p.id = n.id WHERE u.id in ($id)";

其中 $selected 是一个数组 array(1,2,3)。但是当我运行它时，会出现这个通知:

Unknown column '1' in 'where clause'

如何处理这个问题？谢谢

Answer 1

在这里你可以这样做:

$id = implode("','",$selected);

此查询将运行:

$query = "SELECT u.id, p.brand, n.number FROM `user` u LEFT OUTER JOIN `phone` p ON u.id = p.id LEFT OUTER JOIN `number` n 
ON p.id = n.id WHERE u.id in ('$id')";