Re: 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 ones that are already past, so I presume you should have a > then? On Tue, 2003-02-25 at 12:10, Sunfire wrote: > 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 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >