Bagaimana Cara Query untuk Menjumlahkan Transaksi Pertanggal

Assalamualaikum Warahmatullahi Wabarakatuh...
 
saya mau tanya bagaimana caranya menjumlahkan transaksi pertanggal bagaimana rumusnya
mohon informasinya
 
berikut ikut codenya yang ada :
 
<?php
		$bulan = $_GET['bulan'];
		echo date('F Y', strtotime($bulan));?></h5></b></center>
	<?php echo"</div>
	<div style='height:5px;'></div>";
 
 
 
	//$sql = mysql_query("SELECT * FROM tb_detail_penjualan group by timestmp LIKE '%$_GET[bulan]%'") or die(mysql_error());
	$sql = mysql_query("SELECT * FROM tb_penjualan where tgl_transaksi LIKE '%$_GET[bulan]%'") or die(mysql_error());
	$no = 0;
	while($p = mysql_fetch_assoc($sql))
	{
		$no++;
		//$sqla = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_penjualan group by tgl_traksasi AND timestmp LIKE '%$_GET[bulan]%'"));
		$sqla = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_detail_penjualan WHERE no_transaksi='$p[no_transaksi]' AND timestmp LIKE '%$_GET[bulan]%'"));
		//$tglnya = mysql_fetch_array(mysql_query("SELECT COUNT(tgl_transaksi) as count FROM tb_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
 
	}
 
$transaksi = mysql_fetch_array(mysql_query("SELECT COUNT(no_transaksi) as count FROM tb_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
$qty = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_detail_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
$total = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='cash' AND timestmp LIKE '%$_GET[bulan]%'"));
$transfer = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='transfer' AND timestmp LIKE '%$_GET[bulan]%'"));
$credit = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='credit card' AND timestmp LIKE '%$_GET[bulan]%'"));
$bca = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bca' AND timestmp LIKE '%$_GET[bulan]%'"));
$mandiri = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='mandiri' AND timestmp LIKE '%$_GET[bulan]%'"));
$maybank = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='maybank' AND timestmp LIKE '%$_GET[bulan]%'"));
$citibank = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='citibank' AND timestmp LIKE '%$_GET[bulan]%'"));
$bni = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bni' AND timestmp LIKE '%$_GET[bulan]%'"));
$mega = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='mega' AND timestmp LIKE '%$_GET[bulan]%'"));
$bri = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bri' AND timestmp LIKE '%$_GET[bulan]%'"));
$cimbniaga = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='cimb niaga' AND timestmp LIKE '%$_GET[bulan]%'"));
 
	echo"<table class='w3-table w3-tiny w3-hoverable w3-bordered tbl' cellpadding='0'>
		<thead>
		<tr class='w3-dark-grey'>
			<th><center>Total Golf Cart</center></th>
			<th><center>Total Transaksi - Cash</center></th>
			<th><center>Total Transaksi - Transfer</center></th>
			<th><center>Total Transaksi - Credit Card</center></th>
			<th><center>Credit Card - BCA</center></th>
			<th><center>Credit Card - Mandiri</center></th>
			<th><center>Credit Card - MayBank</center></th>
			<th><center>Credit Card - BRI</center></th>
			<th><center>Grand Total Transaksi</center></th>
		</tr>
		</thead>";
		echo"<tr>
			<td><center><b>".$qty['qty']."</b></center></td>
			<td><center><b>".number_format($total['total'])."</b></center></td>
			<td><center><b>".number_format($transfer['total'])."</center></b></td>
			<td><center><b>".number_format($credit['total'])."</b></center></td>
			<td><center><b>".number_format($bca['total'])."</b></center></td>
			<td><center><b>".number_format($mandiri['total'])."</b></center></td>
			<td><center><b>".number_format($maybank['total'])."</b></center></td>
			<td><center><b>".number_format($bri['total'])."</b></center></td>
			<td><center><b>".number_format($total['total']+$credit['total']+$transfer['total'])."</b></center></td>	
		</tr>";
?>
<?php