|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
|
|||
|
|||
|
database krone
hello,
i dont know whether this is exactly a database question. 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 |
|
#2
|
|||
|
|||
|
RE: database krone
You can run a php script (or perl, or whatever) via cron to do this...basically, you would do this:
result set = select * from table where field = 'Y' foreach row in result set send mail.... |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > database krone |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|