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. > > 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
Break that down a bit further by searching on DAYOFYEAR(birthday) assuming that birthday is in/converted to the right format for DAYOFYEAR -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
