Hi,
I would like to know if it is possible to create an automatic update system.
I.E I have implemented a small stock control system using PHP and MySQL and currently i am updating the quantity field manually using an update function. I want to implement a sales invoice function where i can input a certain amount of quantity and it automatically adjusts the quantity levels in the database table.
Can somebody please advice me on this situation.
Thanks,
Dhrups
can u have automatic datdabase update? Help.
Moderator: General Moderators
-
blackbeard
- Forum Contributor
- Posts: 123
- Joined: Thu Aug 03, 2006 6:20 pm
I think you're talking about using triggers, which mysql 5 has.
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
http://dev.mysql.com/doc/refman/5.0/en/triggers.html