BillyMako Posted November 3, 2008 Share Posted November 3, 2008 I am putting together an inventory system which keeps count of the stock level. I have the inventory database setup for example: ProductStock 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" ??? I hope I have made sense! Link to comment https://forums.phpfreaks.com/topic/131156-any-way-of-grabbing-new-data-when-table-updated/ Share on other sites More sharing options...
Kieran Menor Posted November 3, 2008 Share Posted November 3, 2008 Why not just decrement the stock level with a query after adding the order to the order table? Link to comment https://forums.phpfreaks.com/topic/131156-any-way-of-grabbing-new-data-when-table-updated/#findComment-680983 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.