".$lab." Printer Inventory
";
$result=mysql_query("SELECT user, ink, toner, Date, Time FROM inventory where id='$id'")or die(mysql_error());
while($row = mysql_fetch_object($result))
{
//time
echo "Last Updated on: ".$row->Date." at ".$row->Time. " by ".$row->user.".";
echo "
";
//Paper
if ($lab == 'Oak' || $lab == 'Maple')
{
$newInk = (11-$row->ink);
echo "Paper needed: ";
echo ($newInk);
echo "
";
}
if ($lab == 'Cedar' || $lab == 'Spruce')
{
$newInk = (15-$row->ink);
echo "Paper needed: ";
echo ($newInk);
echo "
";
}
//toner
$newToner = (1-$row->toner);
echo "Toner needed: ";
echo ($newToner);
echo '';
}
}
?>