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]

Sorry but i dont have your answer

However i was wondering if you could let me know when you find out because i will require something similar very soon.

thanks
Sam

[inlandpac]

Java is your answer unless you use Netscape and then you can use Server Push technology utilizing a combination of scripts.

You can create a C program that will be run 'persistently' via a shell script or crontab which will constantly check your database(s) and see if something is new (by querying mysql processes 'SHOW PROCESSLIST') and then spitting the results (i.e. new processes since last check, new inserts, etc) to the browser.

The other way, to eliminate the need for Server Push to the browser, is to create your crontab entry with 'nohup myscript &'. This will spit your output to a nohup.out file for you to view at any time and will allow you to go about your business and check whenever you want.