อยากทราบวิธีการ select ในเงื่อนไขไตรมาสครับ โดยไตรมาสเป็นแบบงบประมาณราชการ ครับ (กำลังเร่งพัฒนาครับ อีกสองวันน่าจะทำได้)

select c.BudgettypeID, sum(b.Clearbillpay), sum(อื่นๆ 1), sum(อื่นๆ 2) 
from tbbudgetquarter q
left join tbclearbill b on b.Clearbilldate>=q.Budgetquarterstart and b.Clearbilldate<=q.Budgetquarterend
left join tbbudgetcategory c on c.(ตรงนี้ไม่รู้จะจอยยังไงไม่เห็น ชื่อ field ที่เกีียวข้องกัน 55555)
group by c.BudgettypeID, q.Budgetquarterstart
having q.Budgetquaterstart=ไตรมาสที่ต้องการ

select c.BudgettypeID, q.BudgetquarterID quarter, c.Budgetcategoryamount amt, sum(b.Clearbillpay) pay 
from tbbudgetquarter q
left join tbclearbill b on b.Clearbilldate>=q.Budgetquarterstart and b.Clearbilldate<=q.Budgetquarterend
left join tbbudgetcategory c on c.BudgettypeID=b.BudgettypeID
group by c.BudgettypeID, q.BudgetquarterID

from tbbudgetquarter q
left join tbclearbill b 
left join tbbudgetcategory c 

from tbbudgetquarter AS q
left join tbclearbill AS b 
left join tbbudgetcategory AS c 

select tbbudgetcategory.BudgettypeID, tbbudgetquarter.BudgetquarterID Quarter, tbbudgetcategory.Budgetcategoryamount amt, sum(tbclearbill.Clearbillpay) pay 
from tbbudgetquarter
left join tbclearbill on tbclearbill.Clearbilldate>= tbbudgetquarter.Budgetquarterstart and tbclearbill.Clearbilldate<=tbbudgetquarter.Budgetquarterend
left join tbbudgetcategory  on tbbudgetcategory.BudgettypeID=tbclearbill.BudgettypeID
group by tbbudgetcategory.BudgettypeID, tbbudgetquarter.BudgetquarterID

SELECT (QUARTER('2014-01-01') % 4) + 1 AS ShiftQ -- ผลลัพธ์ ไตรมาสที่ 4
SELECT (QUARTER('2014-10-01') % 4) + 1 AS ShiftQ -- ผลลัพธ์ ไตรมาสที่ 1

select c.BudgettypeID, q.BudgetquarterID quarter, c.Budgetcategoryamount amt, sum(b.Clearbillpay) pay 
from tbbudgetquarter q
left join tbclearbill b on b.Clearbilldate>=q.Budgetquarterstart and b.Clearbilldate<=q.Budgetquarterend
left join tbbudgetcategory c on c.BudgettypeID=b.BudgettypeID
group by c.BudgettypeID, q.BudgetquarterID

select c.BudgettypeID, q.BudgetquarterID quarter, c.Budgetcategoryamount amt, sum(b.Clearbillpay) pay 
from tbbudgetquarter q
left join tbclearbill b on b.Clearbilldate>=q.Budgetquarterstart and b.Clearbilldate<=q.Budgetquarterend
left join tbbudgetcategory c on c.BudgettypeID=b.BudgettypeID
group by c.BudgettypeID, q.BudgetquarterID

SELECT tbbudgetcategory.BudgettypeID, tbbudgettype.Budgettype,tbbudgetcategory.Budgetcategoryamount เงินต้น,ABS( SUM( tbclearbill.Clearbillpayer ) - Budgetcategoryamount ) AS เงินคงเหลือ, SUM( tbclearbill.Clearbillpayer ) ไตรมาส1
FROM tbbudgetquarter
LEFT JOIN tbclearbill ON tbclearbill.Clearbilldate >= tbbudgetquarter.Budgetquarterstart
AND tbclearbill.Clearbilldate <= tbbudgetquarter.Budgetquarterend
LEFT JOIN tbbudgetcategory ON tbbudgetcategory.BudgettypeID = tbclearbill.BudgettypeID
LEFT JOIN tbbudgettype ON tbbudgetcategory.BudgettypeID = tbbudgettype.BudgettypeID
WHERE tbbudgetcategory.BudgetyearID = 41
GROUP BY tbbudgetcategory.BudgettypeID

    " BETWEEN '$yeareng2-10-1' AND '$yeareng2-12-31' ";

   "BETWEEN '$yeareng-01-1' AND '$yeareng-03-31' ";

     "BETWEEN '$yeareng-04-1' AND  '$yeareng-06-30' ";

    "BETWEEN '$yeareng-07-1' AND  '$yeareng-09-30' ";

<?php
// ae.php
$qr="select c.BudgettypeID ID, q.BudgetquarterID quarter, c.Budgetcategoryamount amt
, sum(COALESCE( b.Clearbillpay, 0) ) pay 
from tbbudgetquarter q
left join tbclearbill b on b.Clearbilldate>=q.Budgetquarterstart and b.Clearbilldate<=q.Budgetquarterend
left join tbbudgetcategory c on c.BudgettypeID=b.BudgettypeID
group by c.BudgettypeID, q.BudgetquarterID";

$mysql=new mysqli('host', 'user', 'pass', 'dbname');
$rs=$mysql->query($qr); $old_typeID='';
$row=array(); $tr=''; $idx=-1;
while($ro=$rs->fetch_assoc() ){
	$pay=(int)$ro['pay']; $typeID=$ro['ID'];
	if($old_typeID!=$typeID){
		$idx++;
		$row[$idx]=array(
			'TypeID'=>$typeID, 'Budget'=>$ro['amt'], 
			'pay1'=>$pay, 'pay2'=>0, 'pay3'=>0, 'pay4'=>0, 
			'allpay'=>$pay
		);
		$old_typeID=$typeID;
	}else{
		$row[$idx]['pay'.$ro['quarter']]=$pay;
		$row[$idx]['allpay'] += $pay;
	}
}
print_r($row);
?>