Insert via link (no good)

[Anon]

Heya!
Iäm trying to do such a simple(?) thing as insert some data into a mysql table via a link that looks like this:
<a href="votes.php?totalvotes=2&score=10&movie=42">10</a>

and the vote.php looks like this:
<?php
require_once 'Connections/mysql_connect.php');
mysql_select_db($database_mysql_connect, $mysql_connect);
mysql_query ("INSERT INTO reviews ($votescore, $votes)
VALUES ('$score', '$totalvotes') WHERE movieid=$movie;
");

I'm so lost and a total beginner so please help me...

[Anon]

The problem is that it doesn't update the tables as it should =(

[rbenfield]

I don't have time to look at this closely right now but I would assume the problem is that you are using an INSERT instead of an UPDATE. You need to have both. Have a sql statement try to select a record where the movieid is equal to $movie and if it finds a record then use UPDATE and if it does not find one then use INSERT.

Hope that helps,
Richard