update sql to add "1" to a value

[brange]

What is the sql syntax to update a value so it increases with 1.

Say that u got votes value=5

and when u run the query it will be 6. and the next time 7?

[tttommeke]

UPDATE poll SET value++

Not sure about it but I think this would work.

[brange]

update fusion_users set user_votes='++' where user_id=1

and

update fusion_users set user_votes='value++' where user_id=1

didnt work :P

any other suggestions`

edit: Got it :

update fusion_users set user_votes = user_votes + 1 where user_id=1

[bevin347]

tried that... didnt wrk either

[latruwski]

make a copy of your votetable... so then you have:
votetable
votetable_copy

and then use this query:

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...

[krava]

update fusion_users set user_votes = (user_votes + 1) where user_id=1

and it will work. Basically it will just update previous value by adding 1

SQL is really easy :]

[jaymul]

OR You Can use PHP And Store The Current Value As A Varible
Then Make Another Varible With

$vote = "Current Value";
$vote1 = $vote + "1";

[krava]

no need, when he can directly update it via SQL. Most programmers do this mistake and have one overstep that's not needed.

[visitor]

no need, when he can directly update it via SQL. Most programmers do this mistake and have one overstep that's not needed.

its not a mistake -.-