> SELECT * FROM table WHERE
> DATEPART(mm, dateofbirth) = $month AND
> DATEPART(dd, dateofbirth) = $day;
>
> (That's for SQL Server, probably a different function for mySQL but same
> principle)
for mysql:
select stuff from thetable
where month(dateofbirth) = $month
and dayofmonth(dateofbirth) = $day
however, this simple query is not going to satisfy the more general problem such
as finding people with birthdays in the next 10 days
BJ, this might interest you -- http://r937.com/birthdays.html (sql server
syntax)
rudy
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
