[raptrex]

ok my link is suppose to look like this: index.php?foo=1
so it grabs the data from the table with 1
and votes is a number like 2
this works
but when trying to insert the new data back into the database, it doesnt work
plz check my code

PHP Code:

<?php 
$foo=$_GET[foo];
include("config.php");
$query="SELECT * FROM links WHERE id=$foo";
$result=mysql_query($query);

$num=mysql_numrows($result);


$theid=mysql_result($result,$id,"id");
$title=mysql_result($result,$id,"title");
$post=mysql_result($result,$id,"post");
$date=mysql_result($result,$id,"date");
$votes=mysql_result($result,$id,"votes");
$url=mysql_result($result,$id,"url");

$add = $votes+1;
echo "$votes";

mysql_query("INSERT INTO links(votes) WHERE id=$foo VALUES('$add')");
mysql_close();

echo "$title now has $add votes";
?>

[freelancr]

mysql_query("INSERT INTO links(votes) WHERE id=$foo VALUES('$add')");

change to:
mysql_query("UPDATE links SET votes = $add WHERE id = $foo");