RE: [PHP] reminder mail when date is within a month of today.

2003-02-25 Thread Siddharth Hegde
> -Original Message- > From: Petre Agenbag [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 2:38 PM > To: [EMAIL PROTECTED] > Subject: [PHP] reminder mail when date is within a month of today. > > HI > I'm having a bad thinking day. I know it's going to be a very easy > solut

Re: [PHP] reminder mail when date is within a month of today.

2003-02-25 Thread Petre Agenbag
Thanks for the quick response. Just to clarify: $query=mysql_query("select * from TableName where month(FieldNameForDate)=month(FieldOfDate)+1"); Which one of the dates in your query is the system's date and which is the one from the db? Also, I need not just the ones that are true, but also the

Re: [PHP] reminder mail when date is within a month of today.

2003-02-25 Thread Sunfire
well... $query=mysql_query("select * from TableName where month(FieldNameForDate)=month(FieldOfDate)+1"); that should do it.. or at least it does on mine anyways... - Original Message - From: "Petre Agenbag" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 4: