ช่วยทีครับตอนนี้ทำรายงานของแต่ละเดือนได้แล้ว จากโค้ด (ข้างใน) แต่มันรายงานได้แค่ปีเดียว อยากให้ได้หลายๆปีต่อไปเรื่อยๆ(รายละเอียดด้านใน)
จากโค้ดตรงนี้ Code (PHP) <?
$month=array("01","02","03","04","05","06","07","08","09","10","11","12");
for($i=0;$i<count($month);$i++){
$select=mysql_query("SELECT SUM(total_pricea) as Total FROM tb_pricetotal WHERE MONTH(check_ina)='".$month[$i]."'") or die (mysql_error());
$result=mysql_fetch_array($select);
?>
</tr>
<tr>
<td width="196"><? echo "$month[$i]<br>"; ?></td>
<td width="227" colspan="2"><? echo $result['Total']; ?> </td>
<?
}
?>
Tag PHP
Date :
2013-03-05 11:07:12By :
narongsadView :
738Reply :
5
Code (PHP) $year=array(2013,2014,2015);
$month=array("01","02","03","04","05","06","07","08","09","10","11","12");
for($y=0;$y<count($year);$y++){
echo "ปี = ".$year[$y]."<br>";
for($m=0;$m<count($month);$m++){
$select=mysql_query("SELECT SUM(total_pricea) as Total FROM tb_example WHERE MONTH='".$month[$m]."' AND YEAR='".$year[$y]."'") or die (mysql_error());
$result=mysql_fetch_array($select);
echo "เดือน = ".$month[$m]." ราคา = ".$result['Total'];
}
}
ประวัติการแก้ไข
Date :
2013-03-05 11:17:25By :
Ex-[S]i[L]e[N]t
Code (PHP) <?
$year=array(2013,2014,2015);
$month=array("01","02","03","04","05","06","07","08","09","10","11","12");
for($y=0;$y<count($year);$y++){
echo "<table boder=\"1\"><tr><td>";
echo "ปี = ".$year[$y]."<br>";
for($m=0;$m<count($month);$m++){
$select=mysql_query("SELECT SUM(total_pricea) as Total FROM tb_example WHERE MONTH='".$month[$m]."' AND YEAR='".$year[$y]."'") or die (mysql_error());
$result=mysql_fetch_array($select);
echo "<tr><td>";
echo "เดือน = ".$month[$m]." ราคา = ".$result['Total'];
}
echo "</tr></table>";
}
?>
Date :
2013-03-05 12:19:03By :
Ex-[S]i[L]e[N]t
Server 04
Load balance : Server 04
