PDQ/ICGstable.php

<?php
include_once('pdqconnect.inc');

$sql = "select subK.*, date_format(subKdue,'%c-%e') as dueDate from subK 
		where (subKstatus != 'Received') or ( subKLastUpdate > DATE_SUB(CURDATE(), INTERVAL 4 DAY))
		order by subKstatus asc, subKack desc, subKdue asc, subKjob";

$rs=mysqli_query($mydb,$sql) or die(mysqli_error() . "<br>". $sql);
echo "<table border=0>";
echo "<tr><th>Job</th><th>Material</th><th>Description</th><th>Qty</th><th>Due Date</th><th>New</th><th>Status</th></tr>\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 "<tr><td data-subKID='{$row['subKID']}' data-column='subKjob' class='$fontClass updatableDiv'>{$row['subKjob']}</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKmaterial' class='updatableDiv'>{$row['subKmaterial']}</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKdesc' class='updatableDiv center'>{$row['subKdesc']}</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKqty' class='updatableDiv right'>$Qty</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKdue' class='updatableDiv center'>{$row['dueDate']}</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKack' class='updatableDiv center'>{$row['subKack']}</td>";
	echo "<td data-subKID='{$row['subKID']}' data-column='subKstatus' class='updateStatus center' >{$row['subKstatus']}</td></tr>\n";
}
echo "<caption>PDQ Schedule</caption></table>";

?>