php - 如何在 php 中反转

Question

我有这张表，它只是从recv mobile中减去已售出的手机，而不是余额手机中显示的手机，还加上旧行余额和新行。

|Received Mobiles |Mobile i have sold | Balance |
|6                |1                  |  5 
|3                |2                  |  6
|4                |2                  |  8 ----------> total mobiles i have      

但我想反转(从末尾开始计算)这个结果并希望这样显示，因为我想在顶部看到新记录

|Received Mobiles |Mobile i have sold | Balance |
|6                |1                  |  8 ----------> total mobiles i have
|3                |2                  |  3
|4                |2                  |  2 <------- plus with recv mob 3 then - sold mob   

我正在写这个

while ($fetch = mysql_fetch_array($query)) {

$recvtotal += $fetch[recv];
$soldtotal += $fetch[sold];

$balancing += $fetch[recv]-$fetch[sold];
echo "<tr>";
echo "<td>" . $fetch[brand] . "</td>";
echo "<td>" . $fetch[recv] . "</td>";
echo "<td>" . $fetch[sold] . "</td>";
echo "<td>" . ($balancing) . "</td>";

echo "</tr>";


}

Answer 1

为什么不添加 sorting您的查询？只需添加一个 ORDER BY 子句，您就应该能够反转顺序。