|  |  | 
            
              | Code (PHP) 
 $db=new mysqli('host','user','psw','dbname');
$sql="select dte, 0 as status, invoce, descript, rcv, mA, mB, mC, mD, mE, notice from table";
$rs=$db->query($sql) or die( $db->error . "<br>$sql");
$dte = ''; 
$ttl=array('','','<b style="background-color: red">รวมจนถึงวันนี้</b>','R'=>0, 'A'=>0,'B'=>0,'C'=>0,'D'=>0,'');
$d=array('','','<b style="background-color: yellow">รวมประจำวัน</b>','R'=>0, 'A'=>0,'B'=>0,'C'=>0,'D'=>0,'');
echo "<table border=1>
<tr><th>..</th><th>..</th><th>..</th><th>..</th><th>..</th><th>..</th><th>..</th><th>..</th></tr>
";
while($ro=$rs->fetch_assoc()){
   if($ro['dte']!=$dte){
       if( $dte){
          echo "<tr><td>" , implode("</td><td>", $d), "</td></tr>";
          $ttl['A']=$ttl['R']-$d['A'];
          echo "<tr><td>" , implode("</td><td>", $ttl), "</td></tr>";
          $d=array('','','<b style="background-color: yellow">รวมประจำวัน</b>','R'=>0, 'A'=>0,'B'=>0,'C'=>0,'D'=>0);
       } $dte = $ro['dte'];
   }
   $d['R']+=$ro['rcv'];$d['A']+=$ro['mA'];$d['B']+=$ro['mB'];$d['C']+=$ro['mC'];$d['D']+=$ro['mD'];$d['E']+=$ro['mE'];
   $ttl['R']+=$ro['rcv'];$ttl['B']+=$ro['mB'];$ttl['C']+=$ro['mC'];$ttl['D']+=$ro['mD'];$ttl['E']+=$ro['mE'];
   echo "<tr><td>" , implode("</td><td>", $ro), "</td></tr>";
}
echo "<tr><td>" , implode("</td><td>", $d), "</td></tr>";
echo "<tr><td>" , implode("</td><td>", $ttl), "</td></tr>";
 ทดสอบเอาเองนะครับ ไม่ได้ทดสอบ ส่วนที่ขาดที่เกิน ก็ประยุกต์เอาหน่อยครับ
 
 |  
              | 
 ประวัติการแก้ไข
 2015-07-28 15:42:51
 
                
                  |  |  |  |  
                  |  | 
                      
                        | Date :
                            2015-07-28 15:38:46 | By :
                            NewbiePHP |  |  |  
                  |  |  |  |  |  |  |