SQL: SET column1+=value

[eluser]vitoco[/eluser]
You can't use "field += 1", but you can "field = ( field + 1 )" , so your query will be

Code:

$sql = "
UPDATE
    Review
SET
    numHelpful = ( numHelpful  + ".$numHelpful." ),
    numNotHelpful = ( numNotHelpful + ".$numNotHelpful." )
WHERE
    reviewID =".$reviewID;

the () are also optional, but in my opinion the query gets more readable.

Slds