<?php include_once("config.php");
                        $q=listtes("");
                        $i = '';
                        $t = '';
                        $tdhome = 0;
                        $tchome = 0;
                        $id = '';
                        $tgl = '';
                        $awal=true;
                        $r = mysqli_fetch_array($q);
                        do{

                            if($i != $r['transid'] || $t != $r['tanggal'] ){
                                $id  = $r['transid'];
                                $tgl = $r['tanggal'];
                                if(!$awal) echo "<tr><td colspan=3>".$sum."</td></tr>";
                                $sum=$r['harga'];
                            }else if($i == $r['transid'] || $t == $r['tanggal'] ){
                                $id  = '';
                                $tgl = '';
                                $sum+=$r['harga'];
                            }
                            echo "<tr>
                                    <td>".$tgl."</td>
                                    <td>".$id."</td>
                                    <td>".$r['no']."</td>
                                    <td>".$r['nama']."</td>
                                    <td>".$r['harga']."</td>
                                 </tr>";

                                 $awal=false;
                                 $i = $r['transid'];
                                 $t = $r['tanggal'];
                        }while($r =  mysqli_fetch_array($q));
                    ?>