Hey all Hope ya can help. its almost done just having problems with the new data getting inserted into the current table.
foreach($_SESSION as $key => $value) {
$key = $value;
}
echo
$item_number . "<br>" .
$po_number . "<br>" .
$lot_number . "<br>" .
$amount ;
$query = "SELECT * FROM invintory WHERE item_number ='$item_number'";
$result = mysql_query($query)
or die ("couldnt execute query." . mysql_error());
while ($row = mysql_fetch_array($result))
{
$onhand = $row['onhand'];
}
echo
$onhand ;
$newamount=$onhand+$amount;
echo
$newamount;
[color=red]mysql_query("INSERT INTO invintory WHERE item_number ='$item_number'(onhand)
values ('$newamount')");[/color]
mysql_query("INSERT INTO recvied(item_number,po_number,lot_number,amount)
values ('$item_number','$po_number','$lot_number','$amount')");
?>
The part in red seems to be the problem