query("SELECT * FROM shift_sale_vw WHERE date='$date'");
print_r("
| Pump Number |
Fuel Grade |
Unit Price |
Volume |
Amount |
");
while ($row = $shiftSaleReport1->fetchArray()) {
if ($row['number']==$shiftnum) {
print_r(
""
."| ".$row['fp_id']." | "
."".$row['grade_name']." | "
."".decimalAndNumberFormat1($row['price'])." | "
."".decimalAndNumberFormat1($row['volume'])." | "
."".decimalAndNumberFormat1($row['amount'])." | "
."
"
);
}
}
?>