query("SELECT * FROM shift_tank_vw WHERE date='$date'"); print_r(" Tank Number Product Text Open Volume Close Volume Open Water Volume Close Water Volume Open Level Close Level "); while ($row = $shiftTankReport1->fetchArray()) { 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'])."" ."" ); } } ?>