Hello,
This may be slightly off-topic, apologies if so but I was wondering if anyone could point me in the right direction.
I'm currently storing applications from a web site into our mysql DB, our client has a web-based backoffice. He has to refresh his screen every 20 minutes to see the latest applications. Is there any way of using some sort client-server technology to alert the user, via the browser that a new entry has appeared in the DB - I'm already sending an email but this is still not the best solution.
I cannot think of a clean way. One dirty hack is to have an invisible auth-refresh frame that would hit a URL to return the modification timestamp of from show table status. If the modification time is recent enough, force a refresh of the main page. Or even dirtier - optimize the queries so they run fast, and then just auto-fresh the page once a minute or so.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
