SQL Upate query error

[fluiduk]

Hi All

Can anyone see anything wrong with this query, been staring at it for ages but cant spot it, it will be something blatant

mysql_select_db($database_ebaytemplate, $ebaytemplate);
$query = "UPDATE templates VALUES SET 'title' = '$title', 'description' = '$description', 'refurbished' = '$refurbished', 'circ_id' = '$circ_id', 'picture_url' = '$picture_url'". "WHERE 'id' ='$id' LIMIT 1";
mysql_query($query, $ebaytemplate) or die(mysql_error());

The error 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 'VALUES SET 'title' = 'title 2 2', 'description' = 'test', 'refur

Ta
AAron

 

[fluiduk]

No joy with that, still getting an error

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 '(title, description, refurbished, circ_id, picture_url) VALUES

 

[fluiduk]

Thanks for that Augmented, sadly I am still getting an error

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 ''title' = 'title 2 2', 'description' = 'desc 2xcvbcvbcvbcvb', 'r

 

[fluiduk]

Thanks guys all working now

Aaron