Last Day Sales Report
= DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND sale_time < CURDATE()"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(payment)']; //echo "Yesterday Sale".$row['SUM(received)']."
"; } $result = mysql_query("SELECT * FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND sale_time < CURDATE()"); echo "
| Date | Invoice No | Customer | Amount | Paid | Balance | Comments | Actions | "; echo "
|---|---|---|---|---|---|---|---|
| ".$row['sale_time']." | ".$row['invoice']. " | " .$row['customer_name']. " | " .$row['payment']. " | ".$row['received']. " | ".$row['balance']. " | ".$row['comments']. " | Detail"; echo " |
| Totat Sale Rs.".$total." | |||||||