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
