I need some guidelines in the following topic.
I want to develop a monitoring tool which will be updated automatically from MySql. For example, when there is change of state of a value in a table I want to be informed. I am thinking of doing it by checking every X period of time all the values of the table and if the new value is not equal to the previous one then I can go further. How can I set up a timer or a permanent iteration
Do you have any other recommendations for solving this issue

Have PHP get all the DB fields you want and write them out to hidden form fields. Every x seconds submit the form and check the hidden field values against the new DB records. Then write the new records out on the page, and if they aren't the same, add a big red flashing message and maybe a sound. I would code it for you but I'm a bit short on time right now....

HTH,

Snib

<><