Use triggers, plus a queue, and have a script watch that queue.
-Matt On Fri, 20 Aug 2010, Anthony Papillion wrote:
So I'm developing an application that will work within a larger supply chain system. There is a table in the database called 'Items' which holds a list of all items and how many of those items are in stock at a particular location. Fairly regularly, another system will change that table (for example, when a new shipment of items come in) and I need to notified of that change and fire a script to process those changes. How can this be done effectively and reliably? Is there a 'standard' way of doing it? Thanks! Anthony Papillion
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
