在PHP / Mysql中打印重复记录

Question

我正在尝试打印表的重复记录，但在mysql中只有一行获得了echoed.However，这个查询结果是所有重复记录。下面是查询：

$q = mysql_query("SELECT * FROM add WHERE cust_id = '144' GROUP BY cust_id");
$r = mysql_fetch_array($q);
$s = mysql_num_rows($q);

while($s !=0)
{
    echo $r;
    $s=$s-1;
}

代码有什么问题？

Answer 1

你需要遍历整个记录集...您只抓取了第一行：

$resultset = mysql_query("select * from add where cust_id = '144' group by cust_id");
while($row = mysql_fetch_assoc($resultset))
{
   echo $row['column_name'];
}

Answer 2

$q = mysql_query("SELECT * FROM add WHERE cust_id = '144' GROUP BY cust_id");

while($r = mysql_fetch_array($q))
{
    print_r($r);
}

Answer 3

由于GROUP BY子句的存在，您的SQL查询实际上只返回0或1行。您确定这就是您在mysql中执行的查询吗？