php - 在 PHP/Mysql 中打印重复记录

Question

我正在尝试打印表的重复记录，但只有单行得到echoed.然而在mysql中这个查询会产生所有重复的记录。这是查询:

$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

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

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