Adding with php inserting into database?

[pro_se 0]

[b]Hello... I am trying to create a voting system like digg where you click a link and it adds one in a database... [i]this is what i have so far:[/i][/b]

[code]<?
mysql_connect("localhost","poop","monkey");
mysql_select_db("funky");
  $id = $_GET["id"];
  $total_votes = $r['total_votes'];
  $one = 1;
  $add = ($total_votes + $one);
  $sql = "UPDATE links SET total_votes=$add WHERE id=$id";
      $result = mysql_query($sql);
    echo "Plus 1... added...";

?>[/code]

[u]it does not work... maybe someone can help me?[/u]

[toplay 1]

I don't know where $r['total_votes'] is defined, but if you just want to add one to a column's value, you can simply do:

...
$sql = "UPDATE links SET total_votes = total_votes + 1 WHERE id='$id'";
$result = mysql_query($sql);
if (!$result)
    echo 'Not updated. SQL: ', $sql, ' Error: ', mysql_error();
else
    echo "Plus 1... added...";

[pro_se 0]

WOW!!! thanks!!!!