[SOLVED] Setting a value +1 using MySQL UPDATE query?

[N1CK3RS0N]

Hello.

 

I'm trying to set the current value of a row in my SQL table +1 based on the data input. I'm not sure how, if possible, I should use operators in the query.

 

Ideas?

 

Thanks

 

if ( $feedback_rating == 1 ) {
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET feedback_pos + 1 WHERE userid = " . $feedback_to );
} else if ( $feedback_rating == -1 ) {
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET feedback_neg + 1 WHERE userid = " . $feedback_to );
}

[trq]

"UPDATE " . TABLE_PREFIX . "user SET feedback_pos = feedback_pos + 1 WHERE userid = " . $feedback_to