query("SELECT * FROM shift_tank_vw WHERE date='$date'");
while ($row = $shiftTankReport3->fetchArray()) {
if ($row['number']==$shiftnum) {
echo "".
print_r("
| Tank Number |
Product Text |
Open Volume |
Close Volume |
Open Water Volume |
Close Water Volume |
Open Level |
Close Level |
")
."";
}
if ($row['number']==$shiftnum) {
print_r(
""
."| ".$row['tank_id']." | "
."".$row['product_text']." | "
."".decimalAndNumberFormat1($row['open_vol'])." | "
."".decimalAndNumberFormat1($row['close_vol'])." | "
."".decimalAndNumberFormat1($row['open_water_vol'])." | "
."".decimalAndNumberFormat1($row['close_water_vol'])." | "
."".decimalAndNumberFormat2($row['open_level'])." | "
."".decimalAndNumberFormat2($row['close_level'])." | "
."
"
);
}
}
?>