Monthly Sales Report


= DATE_SUB(CURDATE(), INTERVAL DAYOFMONTH(CURDATE())-1 DAY)"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(received)']; //echo "This Month Sale".$row['SUM(received)']."
"; } $result = mysql_query("SELECT * FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL DAYOFMONTH(CURDATE())-1 DAY)"); echo ""; echo ""; echo " "; echo ""; // displaying records. while ($row = mysql_fetch_array($result)) { echo ""; echo ""; } echo ""; echo "
DateInvoice No Customer Amount Paid BalanceComments Actions
".$row['sale_time']."".$row['invoice']. "" .$row['customer_name']. "" .$row['payment']. "".$row['received']. "".$row['balance']. "".$row['comments']. "Detail"; echo "
Totat Sale    Rs.".$total."
"; ?>