title: Listening for changes in a mySQL database (with PHP)
body: <p>Lets say I have a system, in which the operator opens a slot (which creates a new row in a mySQL DB) and then a QR code appears on screen. The user scans it with his iPhone, then presses 'approve', which changes one of the columns in the new row to  <code>true</code>.</p>
  
  <p>How can I make it so when it does change to <code>true</code>, a message will pop up on the operator screen?</p>
  
  <p>I thought of two ways that might be possibly done:</p>
  
  <ol>
  <li>a change in the row can trigger something that will push a message to the operator's machine.</li>
  <li>if the operator can go into a page, that will only load up when the row = <code>true</code>, but I can't figure out how to do that.</li>
  </ol>
  
  <p>If you know how to do some of the stuff I listed above, or have a different idea, please share it, it will be highly appreciated :D</p>