make a copy of your votetable... so then you have:
votetable
votetable_copy
and then use this query:
Code:
update votetable set votes = (select votes from votetable_copy where name like '%latruwski%') + 1 where name like '%latruwski%';
update votetable_copy set votes = (select votes from votetable where name like '%latruwski%') where name like '%latruwski%';
change votetable to your votetable name and change votetable_copy to the copy you made of the votetable.... change latruwski to the name of the person that is voting...
tested and working ^^
edit: here is what this exacly does:
1) update the votetable and set votes = dummy + 1 for voter latruwski
Dummy is like in VB programs or C++ or whatever just a aid... here the copy of the votetable is the dummy... so the query selects votes from the copied table and adds 1.
2) Now the votetable is updated with +1 vote... now the query updates the copy of the votetable to have the same amount of votes.. so now in both tables latruwski will have +1 vote
3) user votes again and process repeats...
note: this is the first thing that came up to me...
edit: instead of with a whole copy of the votes table you could also add 1 column in the votes table and use that as dummy...