prepare("SELECT * FROM sales WHERE date BETWEEN :a AND :b ORDER by transaction_id DESC "); $result->bindParam(':a', $d1); $result->bindParam(':b', $d2); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?>

Transaction ID	Transaction Date	Customer Name	Invoice Number	Amount
STI-00
Total:				prepare("SELECT sum(amount) FROM sales WHERE date BETWEEN :a AND :b"); $results->bindParam(':a', $d1); $results->bindParam(':b', $d2); $results->execute(); for($i=0; $rows = $results->fetch(); $i++){ $dsdsd=$rows['sum(amount)']; echo formatMoney($dsdsd, true); } ?>	prepare("SELECT sum(profit) FROM sales WHERE date BETWEEN :c AND :d"); $resultia->bindParam(':c', $d1); $resultia->bindParam(':d', $d2); $resultia->execute(); for($i=0; $cxz = $resultia->fetch(); $i++){ $zxc=$cxz['sum(profit)']; echo formatMoney($zxc, true); } ?>