<table class="table table-bordered table-hover" cellpadding="3" cellspacing="0">
<tr>
<th width="1%" scope="col">No.</th>
<th width="7%" scope="col">Bulan Claim</th>
<th width="5%" scope="col">Jumlah Data</th>
<th width="15%" scope="col">Detail Claim</th>
<th width="7%" scope="col">Customer</th>
<th width="7%" scope="col">Produk</th>
<th width="5%" scope="col">Status</th>
<th width="5%" scope="col">Aksi</th>
</tr>
<?php
include('koneksi.php');
$sql = mysql_query("SELECT CONCAT(YEAR(tanggal_claim),' - ',MONTH(tanggal_claim)) AS bulan,detail_claim,custumer,produk,status,COUNT(*) AS jumlah_harian FROM tabel_data GROUP BY MONTH(tanggal_claim)");
$no++;

while($data = mysql_fetch_array($sql)){
echo '
<tr bgcolor="#fff" class="small">
<td align="center">'.$no.'</td>
<td align="left">'.$data['bulan'].'</td>
<td align="left">'.$data['jumlah_harian'].'</td>
<td align="left">'.$data['detail_claim'].'</td>
<td align="left">'.$data['custumer'].'</td>
<td align="left">'.$data['produk'].'</td>
<td align="left">'.$data['status'].'</td>
<td ><a href="./tables_view_harian.php?id='.$data['tanggal_claim'].'">'.$data['id'].'<label class="btn btn-info" >DETAIL</label></a></td>
</tr>
';
$no++;
}
?>
</table>