update records problem

[xtiancjs]

Hi, I have a table named brokers and am trying to add numbers from a menu to an existing number in a field named value_votes . I tried it with the UPDATE command in sql but this just replaced my old number not added to it. I know I need to do something along these lines: UPDATE brokers SET value_votes WHERE value_votes = existing number + new number from form , that last little bit is over my head, can anybody help me with that syntax
xtian

[php_b34st]

assuming that you have got the exiting number in a variable called $existing_votes and the new number in a variable called $new_votes you could do something like:

[code]<?php

$new = $existing_votes + $new_votes;

$sql = mysql_query("UPDATE brokers
            SET value_votes
            WHERE value_votes = '$new'");
            
?>[/code]

[master82]

You have the same problem as me, let me know how it goes?

[TylerL]

Show your current code and it'll be easier to help you. It's probably a syntax error.