*******checkdis.php
This pages allows the DC to view all discrepencies
The data fields are: Store number, sku of item, quantity sent, quantity
receieved, and quantity difference
//
Check In Discrepencies
Discrepencies:
|
Store
|
Sku
|
Quantity Sent
|
Quantity Received
|
Quantity Difference
|
//
//
$link=mysql_connect("mysql.tjhsst.edu", "syousuf", "xxxxxxxx");
mysql_select_db("syousuf", $link);
$query= "select * from discrepency";
$result = mysql_query($query, $link);
$num_rows = mysql_num_rows($result);
for($x=0; $x<$num_rows; $x++)
{
$row=mysql_fetch_array($result);
$store=$row["store"];
$sku=$row["sku"];
$qsent=$row["qsent"];
$qreceived=$row["qreceived"];
$qdiff=$row["qdiff"];
Print<<
$store |
$sku |
$qsent |
$qreceived |
ENDHTML;
if($qdiff>0)
Print('+');
Print<<
ENDHTML;
}
Print<<
Return to Menu:
|
ENDHTML;
//?>
|