01.<?
02. ob_start();
03. session_start();
04. include("./connect.php");
05.?>
08.<head>
09.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
10.<title></title>
11.</head>
12.
13.<body>
14. <div id="mainContent">
15. <table width="100%" border="0" cellpadding="0" cellspacing="0">
16. <tr>
17. <td><br />
18. <?
19. $query = mysql_query("
20. SELECT product.id_prd,sum(order_detail.number) as order_num,in_stock_prd,name_prd
21. FROM order_detail,product
22. WHERE product.id_prd=order_detail.ref_id_prd
23. GROUP BY ref_id_prd
24. ORDER BY order_num DESC");
25. $sum=$row['in_stock_prd']-$row['order_num'];
26. $i=1;
27. ?>
28. <p align="center"><center><h3>ยอดสินค้าทั้งหมด</center></h3></p>
29.<table align="center" border="1" cellpadding="8">
30.<tr bgcolor="#00FF00">
31.<td align="center"><div align="center">คงเหลือในคลังทั้งหมด</div></td>
32.</tr>
33.<?php while ($row = mysql_fetch_array($query)) { ?>
34.<tr>
35.<td align="center"><?php echo $sum; ?></td>
36.</tr>
37.<?php $i++; } ?>
38.</table>
39.<p> </p>
40. </td>
41. </tr>
42. </table>
43. </div>
44.</body>
45.</html>
