rudy and Matt, Thanks for the answers; I had been through that page... ;-(
CURRENT_DATE won't work for this unless there is a way of putting current_date -1 or -2, and I am wanting an automatic check every day for a day ahead, which would then initiate emails. But this looks as though this might be the basis of what I need (from Matt's suggestion) SELECT name, email FROM foo WHERE DAY()=2 AND MONTH()=03; I was hoping to find a ready-made script to do this but so far no success. Joseph Time, where does the time go? > > Or, rudy, have I missed something? > > yes, under Date Functions ;o) > > all databases, mysql included, have functions to extract any part of the date > you wish > > for example, > > ... where month(duedate) = month(current_date) > > extracts all duedates in the current month, eh > > CURRENT_DATE is another special date function > > > i dunno where people get the idea sql is difficult... > > ;o) ____ 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.
