Hey all🙂 ive been away from php/mysql progaming for some time and decided to come back to try and help the company im working for. there idea of pasing along informaiton is printing off of one computer and walking it down the hall to have some one enter the info on there computer.
im doing ok on the basics but now i need to have it not only insert the data into one table but also add the amount to another table.
foreach($_SESSION as $key => $value) {
$key = $value;
}
echo
$item_number . "<br>" .
$po_number . "<br>" .
$lot_number . "<br>" .
$amount ;
mysql_query("INSERT INTO recvied(item_number,po_number,lot_number,amount)
values ('$item_number','$po_number','$lot_number','$amount')");
that works fine but like i said i need it to grab the current ammount in a table called invintory and add the new amount recived and then insert the new amount into the invintory table. i was trying to use item_number to get the info out of the invintory table because that is the varible they have in common.
ahhh hope you can understand what im trying to do and help me out.
