write a script that will access the information, then use a CRON to schedule the collection at whatever intervals suite your needs.
Bastien
From: "Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Subject: MySQL data harvester Date: Tue, 2 Nov 2004 10:05:50 -0600
My office purchased 21 fascinating cell phones that have GPS locaters and bar codes.
When we scan a bar code with one of these cell phones, the data is sent to a
third party company; information about this scan is stored on their
database.
I have installed a "harvester" on my pc that downloads this data off of the third party database into my own MySQL database.
I want to link this data with my other tables to modify my inventory information.
What is the best way to continuously update all tables when new transactions
occur? With MS SQL Server or ORACLE I would write a stored procedure or
trigger that could do this.
What tools can I use with MySQL instead of procedures or triggers?
Matthew
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
