There was a problem with an sql server and my voting system set back people 1 day. I want to make it up to them and give them 1 point increase to make up for the loss.
How would I go about doing that? I was thinking of this but I don't think it would work..
SELECT votepoints FROM vsystem where votepoints=votepoints+1
No. What you are saying is like search where the result equals the result plus 1. That won't be true.
You can UPDATE your table:
...or get the results + 1 (without modifying the table):