Hi Guys
Im trying to update a database with something like the following only it doesnt work, can anyone help plz.
mysql_connect($host,$user,$pass);
@mysql_select_db($db) or die( "Unable to select database");
$query = "UPDATE extra_field SET WHERE product='17666' AND fieldid='3' VALUES (item='$head')";
$query = "UPDATE extra_field SET WHERE product='17666' AND fieldid='4' VALUES (item='$friend')";
$query = "UPDATE extra_field SET WHERE product='17666' AND fieldid='5' VALUES (item='$basecolor')";
$query = "UPDATE extra_field SET WHERE product='17666' AND fieldid='6' VALUES (item='$basetype')";
$query = "UPDATE extra_field SET WHERE product='17666' AND fieldid='7' VALUES (item='$feet')";
mysql_query($query);
mysql_close();
many thanks
