Greetings everyone,
I have a mysql database with several tables. Whenever any updates are made in any of the tables, I want it to:
1) automatically send an email notification with a fixed format to a specific group of users.
OR
2) (manually) ... if the user presses a button on the php page, it will check to see if any new updates have been made to the database/tables since the last update, and then send an email notification with a fixed format to a specific group of users.
** Users can manually add or delete the users in the mailing list.
Can somebody provide me with sample sql and php codes to get everything working?.... i'm relatively new to php, so i would appreciate if anyone can show me step-by-step from the ground up... thank you so much.
PS - Since i'm using PEAR😃B, i am using generic sql statements instead of proprietary mysql syntax.
Regards,
Nick
