running program after insert w/MySQL 4.1
| From: | bill | Date: | Fri, 07 Jul 2006 19:11:07 +0000 |
| Subject: | running program after insert w/MySQL 4.1 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42190@lists.php.net to get a copy of this message | ||
I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day.
After each insert, I need a PHP program run.
Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial.
What else can I do? Is there any way to trigger something via the ODBC connection?
A cron job?
I'm open to suggestions.
kind regards,
bill