I have decided that the inventory can be updated in the back office (I used my own coding for it). When the manager goes to process the item for shipping the inventory will be updated. In order to do that I added a new column to the order_items table for the inventoryid to be passed from the inventory table to the order_items table. In the confirm.php page I have the record set rsInventory which is inner joined with the products table. The record set brings up correct info when I test it. I added a session variable inventoryid. I added the information to the order_items query. When I get to the confirm page something is not working since I get the message:
Notice: Undefined variable: row_rsInventory in /Applications/MAMP/htdocs/megan_isaacs_cms/confirm.php on line 15
Notice: Undefined offset: 5 in /Applications/MAMP/htdocs/megan_isaacs_cms/WA_eCart/WA_eCart_Database_PHP.php on line 17
Column 'inventoryid' cannot be null
Not sure what I did wrong, since the ecart system uses the database.php script.