这就是我的桌子的样子:
NameAmount
foreach($link->query('SELECT ident,COUNT(*) FROM sales GROUP BY ident ASC') as $row) {
echo "
";echo "
img here";$sql = "SELECT * FROM users WHERE ident='{$row['ident']}'";
$resultt = $link->query($sql);
if ($resultt->num_rows > 0) {
while($roww = $resultt->fetch_assoc()) {
echo "
" . $roww['fullname'] . "";}
}
echo "
" . $row['COUNT(*)'] . "";echo "
";}
?>
我将限制查询行仅为3行,以显示第一,第二和第三位。 在foreach($link->查询('SELECT ident,COUNT(*)FROM sales GROUP BY ident ASC')as$ROW){上。如何执行类似IF$ROW==1,IF$ROW==2或IF$ROW==3的检查?