Listen for a Database change

Question

I'm working on a game where multiple laptops (16-20) will be playing the same swf file in flash player.

I need to know if there is a way for the flash movie to listen to a mySQL database for a value change.

For example:

The flash movie is stopped and checks the database if a value has change from 0 to 1. Once the value changes to 1, it will play the next frame.

I need a control where all 16-20 laptops play the next frame at the same time. One admin will dictate this action.

I open to suggestions if there's a better solution that I'm not thinking of.

kglad · Answer

you'll either have to repeatedly poll the database using loadvars and server-side script or use the xmlsocket class and server-side script.

Sign up