SQL insert

[Chimps]

I have the following code but it doesn't seem to work. No data is added to the database. Any ideas? Thanks.

<?php
include("agenda_info.inc.php");

$name = $_POST['name'];
$phone= $_POST['phone'];
$email = $_POST['email'];

$temp_user_id = $_COOKIE['user_id'];

$query = "INSERT INTO contacts('id', 'con_name', 'con_phone', 'con_email')
VALUES('$temp_user_id','$name,'$phone','$email') WHERE id='$temp_user_id'";

mysql_query($query, $link);
mysql_close($link);
?>

[planetsim]

$query = "INSERT INTO contacts('id', 'con_name', 'con_phone', 'con_email')
VALUES('$temp_user_id','$name,'$phone','$email') WHERE id='$temp_user_id'";

try

$query = "INSERT INTO contacts(id, con_name,con_phone, con_email)
VALUES('$temp_user_id','$name,'$phone','$email') WHERE id='$temp_user_id'";

I also suggest adding

or die(mysql_error()) to mysql_query($query, $link);

so mysql_query($query, $link)or die(mysql_error());

Will help in future if you ever get any errors with it.

[Chimps]

I've tried that but it still does not work. The error I am getting is:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id='17'' at line 1

I don't know if this helps, but there is also another field in this table which is called "con_id", which is the primary key and is auto_increment.

Any help is apreciated. Thanks.

[ziong]

"INSERT" statement CANNOT have "WHERE".
it doesn't make sense.