Detect if certain db table rows are set?
<p>Hi I want to create a script which detects if certain rows in a mysql table no longer are empty. </p>

<p>I guess i need to run a php script every 5th second which checks certail table rows. If any of them are empty it should continue updating. If not it should redirect to another php page which shows the updated/filled tables. </p>

<p>Any ideas on how to do this?</p>

<p>It is kind of like the game "who wants to be a millionaire" where x persons gets the same question which they need to answer. Answering them will store their answers in certain table rows. When these rows are not empty the main page needs to show all answers and how long time they have spent answering them. </p>

<p>I just need the updste each 5th second script which returns "true" or "false" (if any of the rows are empty). </p>

<p>Cheers,</p>

<p>Mads</p>
