View Full Version : how to compare the date??

02-01-2007, 03:32 PM
hi, i hav a problem here which is....i need to do a condition to send an email to patient every half a year....for eg, the last treatment date for patient A is 2007-01-01, then email will send to him when the date is 2007-06-01....im confuse how to set this kind of condition....can anyone help me pls....

thanks you

02-01-2007, 04:27 PM
Try google for PHP datediff, you should find a bunch of algorithms to perform this. If you're grabbing the info from mysql you can do it conditionally based on DATEDIFF() ...