Re: 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" <internet@linuxhelp.co.za> To: <php-general@lists.php.net> Sent: Tuesday, February 25, 2003 4:07 AM 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 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, each time I access the page, > it must generate a table with those who's subscription is going to > expire in this month, as well as those who might already be past the > renewal date. > I can handle the generation of the table and all, I'm just not coping > with the query string. > > Thanks > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003