Grabbing newly enetered data from table once updated
Expand Post »
I am putting together an inventory system which keeps count of the stock level.
I have the inventory database setup for example:
Product Stock_level
Battery1 25
Whenever "Battery 1" is bought, it adds a row to the "orders_products" table.
Is there a way where i can have an update button which will check to see if there are any new rows since the last press of the update button which will allow me to deduct 1 off the stock level of "Battery 1" ???
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
