01.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
02.<table width="800" border="0" align="left" cellpadding="0" cellspacing="2">
03.<?php
04.include "connect.php";
05.
06.$i=1;
07.$q="
08.SELECT products.pro_id,products.pro_name,SUM(orders_detail.order_num) AS sum_qty
09.FROM orders
10.INNER JOIN orders_detail ON orders.order_id=orders_detail.order_id
11.INNER JOIN products ON products.pro_id=orders_detail.pro_id
12.WHERE YEAR(orders.order_date)='2015'
13.GROUP BY products.pro_id
14.ORDER BY sum_qty DESC;
15.";
16.
17.$qr=mysql_query($q);
18.$numItem=mysql_num_rows($qr);
19.$numCol=4;
20.$remainCol=$numCol-($numItem%$numCol);
21.while($rs=mysql_fetch_array($qr)){
22.?>
23.<?php if($i%$numCol==1){ ?>
24.
25. <tr>
26. <td width="160" align="center" valign="baseline"><p>
27. <img src="images/<?=$rs[pro_image]?>" width="80">
28. <img src="imgicon/01.gif" width="21" height="9"></p>
29. <p>
30. <?=$rs[pro_type]?>
31. </p>
32. <p> <a href="#">ราคา</a> :
33. <?=$rs[pro_price]?>
34. <a href="#">บาท</a></p>
35. <p>
36. <?=$rs[pro_times]?>
37. </p>
38. <p><a href="basket_add.php?id=<?=$rs[pro_id]?>"><img src="imgicon/shoping_icon.jpg" width="100" height="25" /></a><br></p></td>
39.<?php } ?>
40.<?php if($i%$numCol==2){ ?>
41. <td width="160" align="center" valign="baseline"><p><img src="images/<?=$rs[pro_image]?>" width="80"> <img src="imgicon/01.gif" width="21" height="9"></p>
42. <p>
43. <?=$rs[pro_type]?>
44. </p>
45. <p> <a href="#">ราคา</a> :
46. <?=$rs[pro_price]?>
47. <a href="#">บาท</a></p>
48. <p><?=$rs[pro_times]?>
49. </p>
50. <p><a href="basket_add.php?id=<?=$rs[pro_id]?>"><img src="imgicon/shoping_icon.jpg" width="100" height="25" /></a></p></td>
51.<?php } ?>
52.<?php if($i%$numCol==0){ ?>
53. <td width="160" align="center" valign="baseline"><p><img src="images/<?=$rs[pro_image]?>" width="80"> <img src="imgicon/01.gif" width="21" height="9"></p>
54. <p>
55. <?=$rs[pro_type]?>
56. </p>
57. <p> <a href="#">ราคา</a> :
58. <?=$rs[pro_price]?>
59. <a href="#">บาท</a></p>
60. <p>
61. <?=$rs[pro_times]?>
62. </p>
63. <p><a href="basket_add.php?id=<?=$rs[pro_id]?>"><img src="imgicon/shoping_icon.jpg" width="100" height="25" /></a></p></td>
64. </tr>
65.<?php } ?>
66.<?php $i++; } ?>
67.<?=($remainCol>0 && $remainCol!=$numCol)?"<td colspan=".$remainCol."></td></tr>":""?>
68.<?php
69.echo $sql3."<br>";
70.mysql_query($sql3) or die(mysql_error());
71.
72.?>
73.</table>
Load balance : Server 04
