query("SELECT * FROM shift_sale_vw WHERE date='$date'");
//Shift 1
while ($row = $shiftSaleReport->fetchArray()) {
if ($row['number']==$shiftnum) {
print_r("
| Shift Id: |
Shift Date: |
Shift Number |
Shift Opening: |
Shift Closing: |
");
print_r(
""
."| ".$row['shift_id']." | "
."".$row['date']." | "
."".$row['number']." | "
."".$row['open_date']." | "
."".$row['close_date']." | "
."
"
);
break;
}
}
?>