DATE_SUB(CURDATE(), INTERVAL 4 DAY))
order by subKstatus asc, subKack desc, subKdue asc, subKjob";
$rs=mysqli_query($mydb,$sql) or die(mysqli_error() . "
". $sql);
echo "";
echo "| Job | Material | Description | Qty | Due Date | New | Status |
|---|
\n";
while($row=mysqli_fetch_array($rs)){
if(strlen($row['subKjob'])>9){
$fontClass='smaller';
} else {
$fontClass='';
}
// $Vname = $row['Vname'];
$Qty = number_format($row['subKqty'],0);
echo "| {$row['subKjob']} | ";
echo "{$row['subKmaterial']} | ";
echo "{$row['subKdesc']} | ";
echo "$Qty | ";
echo "{$row['dueDate']} | ";
echo "{$row['subKack']} | ";
echo "{$row['subKstatus']} |
\n";
}
echo "Schedule
";
?>