Hi
If I do this and projectdonations is say 5 sqlst = "update sfproducts set projectdonations = projectdonations + 1 WHERE prodID = '" & sProdID & "'" projectdonations then = 6 - great however the number I want to add is in a variable called test value and if I do this and say testvalue is 66 sqlst = "update sfproducts set projectdonations = projectdonations + &testvalue WHERE prodID = '" & sProdID & "'" projectdonations then = 566 so its appending rather than adding. Im sure its just a syntax thing but for the life of me I can work it out pointers appreciated. Regards John Berman --------------------------------------------------------------------- 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