Cron Task Help

[webbrowser]

Hi All,
I need help creating a cron task to check the single value of a field stored in our mysql database. The value should be always set to 0 (Zero). Is there some way of checking this periodically and changing this back to zero from 1 if it has changed and sending an email letting me know if it has been modified??

A single value within a static table without the need to search through a series of records.

Its a long story why I need to do this but this would be the easiest way for me to monitor this if something untoward was happening.

Thanks for any replies in advance.

[dagon]

what exactly do you need help with?
mysql query "update foo set bar=0 WHERE bar=1"

[webbrowser]

I have no problem actually updating the field. I really just want to be alerted if it has changed.

[bradgrafelman]

So use something like [man]mysql_affected_rows/man to see if the UPDATE query changed any rows or not and, if so, send the desired notification.