php - Where 子句中的数组

Question

如何将数组插入到 where 子句中？这是获取 ID 的第一个查询:

$query = "SELECT id FROM #_categories WHERE alias = 'agenda'";
$result = mysql_query($query) or die(mysql_error());
   while($linha = mysql_fetch_array($result)){
   $vNome = $linha['id']; 
}

现在第二个查询得到最终结果:

$query = "SELECT introtext FROM $tabela WHERE catid IN ($vNome) <> ''";

结果是:

SELECT introtext FROM #_content WHERE catid IN (36) <> ''

为什么我不能将所有 ID 放入子句 IN 中？

PS:抱歉英语不好，这不是我的母语。

Answer 1

$vNome=array();
$result = mysql_query($query) or die(mysql_error());
  while($linha = mysql_fetch_array($result)){
  $vNome[] = $linha['id']; 
}

然后是sql:

$query = "SELECT introtext FROM $tabela WHERE catid IN (".implode(",",$vNome).")";