Date as Header Row in PHP MySQL [solved]

After long bang bang and stackflow here is what i found to :
Date as Row Header
Daily Report Table in Using MySQL & PHP

How You will love it

<?php include('config.php'); $result = mysqli_query($con, 'select * from sform where date_format(csdate,"%Y") != "1969" order by csdate ASC'); $dateSection = ""; echo '<table width="100%">'; while($row = mysqli_fetch_assoc($result)) { $dateHeader = date("d-M, Y", strtotime($row['csdate'])); if ( $dateHeader != $dateSection ) { $dateSection = $dateHeader; echo '<tr><td colspan="5" style="background:#000;color:#fff; text-align:center; padding:8px; font-weight:bold;">' . $dateHeader .'</td></tr>'; } echo '<tr>'; echo '<td>#' . $row["rno"] . '</td>'; echo '<td>' . $row["cname"] . '</td>'; echo '<td>' . date('d-M, Y @ h:i A', strtotime($row["csdate"])) . '</td>'; echo '<td>' . $row["cphone"] . '</td>'; echo '<td>' . $row["caddr"] . '</td>'; echo '<td>' . $row["csnop"] . '</td>'; echo '</tr>'; } ?>

MYSQL - Group by date and Sum by Everyday

If want to calculate sum of everyday here is simple ways to do it

Sum of Everyday Descending Order in MySQL

select date(csdate) as xdate, sum(ifare) as total from rform group by date(csdate) order by date(csdate) DESC

Sum of A Day in Mysql

select csdate, ifare from rform where date(csdate) = "2015-09-21"