rudy, I've checked that MySQL is returning for straight select and where where is simple. But with your revised script this is the result:
Database loop - Table loop_allname running on localhost Error SQL-query : SELECT first_n, last_n, email_address, birth FROM loop_allname WHERE datediff( date_add( birth, INTERVAL year( current_date ) - year( birth ) year ) , current_date ) BETWEEN 0 AND 1 OR datediff( date_add( birth, INTERVAL year( current_date ) + 1 - year( birth ) year ) , current_date ) BETWEEN 0 AND 1 LIMIT 0 , 30 MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( date_add( birth, INTERVAL year( current_date ) - year( birt I tried putting '`' round the field names as well, but the result is the same. Syntax is all the punctuation instructions isn't it? I can't see much else to try! And I thought it was fairly simple. Joseph > select first_n, last_n, email_address, birth > from loop_allname > where datediff( > date_add(birth > , interval year(current_date) > -year(birth) year ) > , current_date ) > between 0 and 1 > or datediff( > date_add(birth > , interval year(current_date) + 1 > -year(birth) year ) > , current_date ) > between 0 and 1 ____ • 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.
