> > > No argument - but I have to understand it too ?;-( > > yes, you do > > ;o)
I'm not sure if I do understand it... but you sent me scurrying round to discover what it means and how to do it, and I have adapted this SELECT id, first, middle, last, dod, DATE_FORMAT(dob, '%M %e, %Y') as nicedob, YEAR(NOW())-YEAR(dob) AS birthday FROM people WHERE MONTH(NOW()) = MONTH(dob) ORDER BY DAYOFMONTH(dob); to this SELECT `first_n` , `last_n` , `email_address` , DATE_FORMAT( `birth` , '%d %m, %Y' ) AS birthlist, YEAR( NOW( ) ) - YEAR( `birth` ) AS birthday FROM `loop_allname` WHERE DAYOFMONTH( NOW( ) )+1 = DAYOFMONTH( `birth`) which appears to do exacly what I wanted (ie pull out all the birthdays on a particular day - July 4 on July 3). The original pulls all the birthdays for a whole month, so I think I have work to do for end of month, end of year - OR better, I will set the cron for one minute after midnight and leave out the '+1'. It seems the host probably has MySQL 4.0.x, but I have asked them to check my server (they also have some 4.1.x). I had googled many times, but only after your last mail did I get to this. So thank you again. I didn't get to finish working on TO_DAYS() but I was starting to see what it did. 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.
