如何制作一个总数据插入表？

Question

我想要自动计算销售，费用和银行存入的总额

<?php

$result = mysql_query("select * from new");

$x = 0;
while($row = mysql_fetch_assoc($result))
{
?>

<tr>
    <td><?php echo $row["D_date"]; ?></td>
    <td><?php echo $row["D_id"]; ?></td>
    <td><?php echo $row["D_item"]; ?></td>
    <td><?php echo $row["D_sales"]; ?></td>
    <td><?php echo $row["D_expenses"]; ?></td>
    <td><?php echo $row["D_bankin"]; ?></td>
</tr>

<?php
$x++;
}
?>

<?php

$result1 = mysql_query("select * from new");
while($row1 = mysql_fetch_assoc($result1))
{
?>
    <tr>
        <td colspan="3">Total</td>
        <td><?php echo $row1["D_totalsales"]; ?> </td>
        <td><?php echo $row1["D_totalexpenses"]; ?></td>
        <td><?php echo $row1["D_totalbankin"]; ?></td>
    </tr>
<?php
}
?>

谢谢

Answer 1

不需要为此触发两个查询。您可以在单个查询中执行相同的操作。

将查询更改为

$results = mysql_query("SELECT *,SUM(`D_sales`) as D_totalsales ,SUM(`D_expenses`) as D_totalexpenses ,SUM(`D_totalbankin`) as D_totalbankin FROM new");

while($row = mysql_fetch_assoc($result))
{
?>
<tr>
  <td><?php echo $row["D_date"]; ?></td>
  <td><?php echo $row["D_id"]; ?></td>
  <td><?php echo $row["D_item"]; ?></td>
  <td><?php echo $row["D_sales"]; ?></td>
  <td><?php echo $row["D_expenses"]; ?></td>
  <td><?php echo $row["D_bankin"]; ?></td>
  <td><?php echo $row["D_totalsales"]; ?></td>
  <td><?php echo $row["D_totalexpenses"]; ?></td>
  <td><?php echo $row["D_totalbankin"]; ?></td>
</tr> 
?>

Answer 2

 SELECT SUM(D_sales), ... FROM table_name

Answer 3

您可以使用mysql_num_rows()

echo mysql_num_rows($result);