[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 solution, but please humour me. I have a mysql table with a bunch of subscribers and the date that they subscribed. I want to query the table to find all the subscribers who will come up for renewal within the current month. So,

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

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:07 AM

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

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.

-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 solution, but