query("SELECT SERVICEPROVIDER FROM recievables GROUP BY SERVICEPROVIDER DESC"))
{ while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; }
}
$connect->close();
?>
Local Purchase Orders supplied by
S/Number
Date
Company
Item description
Amount
LPO No.
prepare("SELECT * FROM recievables WHERE SERVICEPROVIDER BETWEEN :a AND :b ORDER by id DESC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
O-0
Total:
prepare("SELECT sum(SUBTOTAL) FROM recievables WHERE SERVICEPROVIDER BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(SUBTOTAL)'];
echo formatMoney($dsdsd, true);
}
?>