เช่น
เลือกเฉพาะ record ฟิลเก็บวันที่ ตรงกับเดือนนี้
$sum_thismount = "select sum(b.bonus) as total_bonus from $tbl_Wanted as a left join $tbl_WantedBonus as b on a.wanted_ID=b.wanted_ID where a.member_id='".$ssRecord["member_id"]."' and date_approve='thismonth'";
Tag : - - - -
Date :
30 ต.ค. 2550 18:18:48
By :
roodzip
View :
1855
Reply :
1
No. 1
Guest
$sum_thismount = "select sum(b.bonus) as total_bonus from $tbl_Wanted as a left join $tbl_WantedBonus as b on a.wanted_ID=b.wanted_ID where a.member_id='".$ssRecord["member_id"]."' and MONTH(date_approve)='thismonth'";
Load balance : Server 02
