Stewart, > All you should have to do is wrap the statement in () like: > UPDATE <table name> SET field=(field+1) WHERE <where clause>
I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html). Where did you find the requirement for parentheses? Do you have live code where UPDATE works with parentheses, but fails without them? Please advise, =dn PS with regard to your question about the original post, Tyler's problem was elsewhere and has been solved. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
