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>