Re: Birthdays!
| From: | Marco Tabini | Date: | Mon, 14 Oct 2002 20:34:01 +0000 |
| Subject: | Re: Birthdays! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22390@lists.php.net to get a copy of this message | ||
How about
select * from table where birthday between now() and date_add(now(),
interval 15 day);
Assuming, of course, you're using MySQL.
Cheers,
Marco
On Mon, 2002-10-14 at 16:20, Steve Vernon wrote:
> Hiya,
> Just wondering what is the best way to do this please.
>
> I have various birthdays stored as dates including birth years.
>
> Just wondering is there a function, or an easy way to work out the birthdays in the next
> two weeks say. Just be nice on my website to remind me of birthdays.Suppose its simple to work out
> manually, but then have to mess around with days a month etc.
>
> Thanks,
>
> Steve
> XX