Increase numbers via update

[jedijeff]

I am looking to creating a voting system. I would have two buttons, a "good" and "bad" button.

In my mySQL database, there is a column for "good" and another for "bad". Every time the "good" button is clicked, the number in the "good" column is increased. Every time the "bad" button is clicked, the number in the "bad" column is increased.

[djjjozsi]

$sql='UPDATE mytable';
if(isset($_POST["bad"]))
$sql.=' SET bad=bad+1 WHERE itemid=' . intval($_POST["bad"]);
elseif(isset($_POST["good"]))
$sql.=' SET good=good+1 WHERE itemid=' . intval($_POST["good"]);

echo $sql;

[halojoy]

   UPDATE table
   SET good = good + 1
   WHERE id=xxxx