| Bastien Koert 2004-11-02, 3:55 pm |
|
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@fmo.hctx.net>
>To: php-db@lists.php.net
>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
>
|