01.$query = "SELECT SUM(order_total) AS totol, DATE_FORMAT(order_date, '%d-%m-%Y') AS datesave FROM order_detaila GROUP BY DATE_FORMAT(datesave, '%d%')";
02.$result = mysqli_query($con, $query);
03.
04.
05.?>
06.<h3 align="center">รายงานแยกตามวัน</h3>
07.<table width="400" border="1" cellpadding="0" cellspacing="0" align="center">
08. <thead>
09. <tr>
10. <th width="40%">วันที่</th>
11. <th width="60%">ยอดขาย</th>
12. </tr>
13. </thead>
14.
15. <?php while ($row = mysqli_fetch_array($result)) { ?>
16. <tr>
17. <td align="center">
18. <?php echo date('d M Y', strtotime($row['datesave'])); ?>
19.
20. </td>
21. <td align="right"><?php echo number_format($row['totol'], 2); ?></td>
22. </tr>
23.
24. <?php
25. $at += $row['totol'];
26. }
27.
28. ?>
29. <tr>
30. <td align="center">รวม</td>
31. <td align="right" bgcolor="yellow"><?php echo number_format($at, 2); ?></td>
32. </tr>
33.</table>
