选择查询返回一条匹配的记录

Question

大家好，这是我在这里的第一个问题，请指导我，我正在接收一个变量中的id，它可能是2,3,4代表这些id，当我直接在数据库中运行查询时，我正在从数据库中获取数据，当我在文件中使用时，它工作得很好，它只返回第一个匹配的记录，其余的都返回

$resid在此varaibale中，我接收变量

$query_responsibilities_RS = "SELECT * FROM responsibility  WHERE resID IN ($resIDs)";

这是我正在尝试的查询

$respons_RS = mysql_query($query_respons_RS, $timespace) or die(mysql_error());                                                     
$row_respons_RS = mysql_fetch_assoc($respons_RS);
$total_respons_RS = mysql_num_rows($respons_RS);

$rescID = $row_respons_RS["rescID"]; here i need records but it returns one record i want to use this $rescID in second query 

$query_rescategories_RS = "SELECT *  FROM responsibility_category WHERE rescID IN ($rescID)";
$rescategories_RS = mysql_query($query_rescategories_RS, $timespace) or die(mysql_error());
$row_rescategories_RS = mysql_fetch_assoc($rescategories_RS);
$total_rescategories_RS = mysql_num_rows($rescategories_RS);

<?php do{ 
          echo ("<h4>".addcslashes($row_rescategories_RS["rescName"],"\"")."</h4>");
        } while ($row_rescategories_RS = mysql_fetch_assoc($rescategories_RS)); ?>

我使用循环，但我只得到一条记录，但我有多条记录

Answer 1

您应该对它进行循环，尝试以下代码

while($row_respons_RS = mysql_fetch_assoc($respons_RS)) {
 echo $row_respons_RS['rescID'];  //here you will get records 
}

Answer 2

要使用的类型：

do{
$rescID[] = $row_respons_RS["rescID"];
}while ($row_respons_RS = mysql_fetch_assoc($respons_RS));

然后：

$query_rescategories_RS = "SELECT *  FROM responsibility_category WHERE rescID IN (" . implode(",",$rescID) . ")";

Answer 3

删除此行$row_rescategories_RS = mysql_fetch_assoc($rescategories_RS);

从…

$query_rescategories_RS = "SELECT *  FROM responsibility_category WHERE rescID IN ($rescID)";
$rescategories_RS = mysql_query($query_rescategories_RS, $timespace) or die(mysql_error());
$row_rescategories_RS = mysql_fetch_assoc($rescategories_RS);
$total_rescategories_RS = mysql_num_rows($rescategories_RS);

它只能在while循环中使用。

这里

<?php do{ 
          echo ("<h4>".addcslashes($row_rescategories_RS["rescName"],"\"")."</h4>");
        } while ($row_rescategories_RS = mysql_fetch_assoc($rescategories_RS)); ?>