♥bruyndoncx Posted May 31, 2007 Posted May 31, 2007 Hi guys and girls, Recently with mysql 5.0 it is possible to have database triggers http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html I would like to have a (couple of) trigger (s) on the specials table to update the products date modified whenever a special is added, changed or removed. This way I have a record timestamped that can be used to sync the prices with the downstream POS and accounting system. Is there anyone who has done something similar yet in mysql ? When I look at it, I know it shouldn't be too hard, but from experience I know it always takes longer ... :blush: Anyone up for the challenge and doing some pioneering sql work for the old MS2 osCommerce ? Quote KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.