please help me! need ans urgently!

[viperdk]

is it possible to open a constant connection with a mysql database from a client software and "watch" a particular table so that the client will be notified, or preferbly be also reflected on the client software, when any changes (eg. INSERT, UPDATE) are made to that table?
help please!!

thanks!!!!!!!!!

[Anon]

I am confused If by client software u mean any other software then php.

Say For eg: using VB you can do this.

First make one php page where u reterive all the selected fields which u want to display to ur client. This page should display all the data u want to show to your client.

Keep this page refresh in every 60 seconds or so so that this page always shows the updated data.

Now with VB you just call that page in yoour any form.

Hope this helps u .

Chanderjit