php - While 语句中的 Foreach (NumRows)

Question

我试图弄清楚如何在 while 语句中执行 foreach 语句。正如您从这段代码中可以看出的，即使它选择了所有行，它也只会从表中提交 1 行。我如何让它选择每一行？

代码:

$q2 = mysql_fetch_array(mysql_query("SELECT * FROM `ticketreply` WHERE `ticketid`='$id'"));
$num_rows = mysql_num_rows($q2);
while(count($num_rows) > $i){
    echo "<div style='float:left;width:940px;margin-bottom:2%;margin-left:".($i + 1)."0px;margin-right:25%;'><div style='margin-left:".($i + 1)."0px;border:1px solid #cecece;padding:10px;'>Posted By: <a href='#'>".user2($q2[1])."</a><h2>".$q2[2]."</h2></div></div></div>";
    $i++;
}

新尝试:

$q2 = mysql_query("SELECT * FROM `ticketreply` WHERE `ticketid`='$id'");
$i = 0;
foreach($q2 as $s){
    echo "<div style='float:left;width:100%;margin-bottom:2%;margin-left:".($i + 1)."0px;margin-right:25%;'><div style='margin-left:".($i + 1)."0px;border:1px solid #cecece;padding:10px;'>Posted By: <a href='#'>".user2($s[1])."</a><h2>".$s[2]."</h2></div></div></div>";
    $i++;
}

尽管现在不显示任何行。

Answer 1

$q2 = mysql_query("SELECT * FROM `ticketreply` WHERE `ticketid`='$id'");

$i = 0;
while ($s = mysql_fetch_array($q2, MYSQL_NUM)) {
    echo "<div style='float:left;width:100%;margin-bottom:2%;margin-left:".($i + 1)."0px;margin-right:25%;'><div style='margin-left:".($i + 1)."0px;border:1px solid #cecece;padding:10px;'>Posted By: <a href='#'>".user2($s[1])."</a><h2>".$s[2]."</h2></div>   </div></div>";
    $i++
}