I have a MySQL database that collects data from the call light system at one of our hospitals. So when a resident is in there room and they push the button on their remote to call for a nurse, it dumps that data into a MySQL database. I have about 40 laptops/desktops on each floor that can view those calls requests on a small web interface but I wanted to see if there was a way to have a small windows app that pings the DB every few seconds for alerts and then would popup a message when it has one. I would want that message to say on the screen until the class was cleared which is just another flag in the table. That way they dont have to have that website loaded up and just sitting there waiting for an error.
anyone know how I could do that? or any easy solutions for something like that?