SQL: SET column1+=value

[eluser]bigbusty[/eluser]
I don't think you can do it this way. You have to update the latest value.

Another thing i thought of could be, just adding a record with "numHelpful" or "numNotHelpful". This way you dont have to get the latest value but instead you could just echo out the count of records. After the vote has expired, you could clear the table.

Code:

$this->db->insert('vote', 'numHelpful');
echo $this->vote_model->get('numHelpful');