I want to add up in a select Statement

2002-08-17 Thread John Berman
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

Re: I want to add up in a select Statement

2002-08-17 Thread Chris Knipe
sqlst = update sfproducts set projectdonations = projectdonations + testvalue WHERE prodID = ' sProdID ' ^^ $sqlst = update sfproducts set projectdonations = projectdomains + . $testvalue . WHERE prodID = ' . $sProdID . '; $sqlstr then looks like this: update sfproducts set