In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> How about
> select * from table where birthday between now() and date_add(now(),
> interval 15 day);
> Assuming, of course, you're using MySQL.
> 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
Break that down a bit further by searching on DAYOFYEAR(birthday) assuming
that birthday is in/converted to the right format for DAYOFYEAR
Quod subigo farinam
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php