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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php