$z="SELECT Inc_Date, SUM(Inc_Amount) FROM income GROUP BY MONTH(Inc_Date)";
$zz=mysql_query($z);
$zzz = mysql_fetch_array($zz);
echo รวม.$zzz['SUM(Inc_Amount)'];
echo เดือน.$zzz['MONTH(Inc_Date)'];
$z="SELECT monthname(Inc_Date) as month_name, SUM(Inc_Amount) FROM income GROUP BY MONTH(Inc_Date)";
$zz=mysql_query($z);
$zzz = mysql_fetch_array($zz);
echo $zzz['month_name']; // ได้ชื่อเดือน
พี่ไดแล้ว ๆ ขอบคุณมาคับพี่ พอดีผมลืมใส่ while ตอนโชว์
Code (PHP)
$z="SELECT monthname(Inc_Date) as month_name, SUM(Inc_Amount) FROM income GROUP BY MONTH(Inc_Date)";
$zz=mysql_query($z);
while($zzz = mysql_fetch_array($zz)){
echo $zzz['month_name'];
}
Load balance : Server 02
