database krone

hello,
i dont know whether this is exactly a php question but my web interface is php.
i have a table in mysql which contains some records. if a particular field is yes i want an e-mail to be sent to the administrator everyday else no action should be taken...so basically i want to check the field everyday at a particular time to see if the value is 'Y' .pls help me as to how to do it...
i have to run a kron...but should i give a select statement?? how do i check whether the value in the field is 'Y'
thanks

if your website doesn't support cron you can do something less elegant by including a query in a page that gets hit every day. Basically you compare the day from date with the day_last_sent and if they aren't the same you send your mail and update the day_last_sent to today.

B

yes shane...u r right its cron
i misspelled it.
also i figured out a solution to my problem....i wrote the whole script in php and then i called the php file in my crontab.
thanks