php - 多个 WHERE AND 查询 - Mysql/PHP

Question

尝试将一个查询的结果放入另一个查询的 WHERE 语句中:

$query1 = "SELECT DISTINCT company_id FROM location WHERE state = 'XX'";
$result1 = mysql_query($query1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)) {
    //Collect WHERE STATEMENT HERE
}

我试过以下方法:

$q1 = "SELECT company FROM company WHERE id = '16', id = '7' ORDER BY company";
$q1 = "SELECT company FROM company WHERE id = '16' AND id = '7' ORDER BY company";
$q1 = "SELECT company FROM company WHERE id = '16' && id = '7' ORDER BY company";

与其他变体一起

Google 只提供了多个 WHERE AND 如果使用不同的表名，而不是相同的。有人有任何指示吗？

Answer 1

通用代码:

$ids = array (
[0] => 2
[1] => 4
[2] => 19
[3] => 16
);  

$ids = join(',',$ids);  
$sql = "SELECT * FROM company WHERE id IN ($ids)";

引用:same example