About query

[turb]

Hi!

i've got a field into my db that is a counter for a poll. Each time a user vote, i have to add 1 to the field value like "field = field+1"

is there a simple way to make my query ... something like :

UPDATE pollList SET partVote ADD 1 ????

turb

[YappyDog]

UPDATE pollList SET partVote = partVote + 1

That'll add one to every row in the table. You probably want to add in something about UserID = something