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)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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



Reply via email to