> > SELECT * FROM table WHERE > DATEPART(mm, dateofbirth) = $month AND > DATEPART(dd, dateofbirth) = $day; > >
Bj, I'm hitting the same error with yours as with rudy's (#1064) DATEPART() doesn't seem to be part of this version of MySQL, and I imagine I would have to use DAYOFMONTH() and MONTH() to extract the information. but it is getting the same objection as rudy's. But now I am thinking that MySQL 4.0.15 might not be the one rudy and you are working to. Joseph ____ • 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.
