> joseph > > first of all, please do us all a favour, particularly those on the digest, and > trim your responses so that you are not echoing the entire post you are > responding to
Strike a better balance between too little and too much ... > > > I only want to pull out one day's celebrants each time > > celebrants for which day? today? tomorrow? Tomorrow. I am intending to set the script to run automatically in the evening (gmt) which will get some mails on the right day and some ahead of time. > > and are you willing to insert the month and day values into the query manually > every time you run the query? > Iwas thinking it might be easy to adapt from a NOW() > > > SELECT email_address FROM loop_email_addresses AND first_n, last_n FROM > > loop_allname > > WHERE emailID=(SELECT nameID FROM loop_email > > WHERE nameID=(SELECT month(10) AND birth_day(3) FROM > > loop_birth)); > > this query will require a lot of work to straighten out I feel a join coming on ;-) > > let's stick to the birthday until we get that solved > > > rudy > With this help I am starting to catch up to where I had got to. I am trying to make an inner join of your query and see if I can make it work through MyAdmin. PS. I realise that between last line needs to be 'between 0 and 1'. 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.
