" .
"
| $value |
" .
"
| Part Number | Stock | " .
"Last Update | . | " .
". |
");
$result2 = @mysql_query("SELECT ID,prodnum,stock,last_date FROM inventory WHERE prodname='$value' ORDER BY prodnum");
if (!$result2){
die ("
Error Selecting Product from Data Base!
".
'Error:' . mysql_error() . '
');
}
while($row2 = mysql_fetch_array($result2)){
if($pswinv == 'All'){
$straw1 = "
[Shipping]";
$straw2 = "
[Receiving]";
}elseif($pswinv == 'Read_Write'){
$straw1 = "
[Shipping]";
$straw2 = "
[Receiving]";
}elseif($pswinv == 'Read'){
$straw1 = "
.";
$straw2 = "
.";
}
$lastdate = chunk_split("$row2[3]", 2, ",");
$listdate = explode(',',$lastdate);
echo("
| $row2[1] | $row2[2] | " .
"$listdate[2]-$listdate[3]-$listdate[0]$listdate[1] | " .
"$straw1 | " .
"$straw2 |
");
}
echo("");
}
?>
