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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
