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
