PDA

View Full Version : Help With query


ac3
Wed 13th Feb '02, 10:33am
$sql = "UPDATE apnews_vars SET (welcomemessage,pagetitle,baseurl,adminname,footer ) VALUES ('$welcomemessage','$pagetitle','$baseurl','$admin name','$footer') WHERE ID = 1";

if(!mysql_query($sql)) {
echo("There was a problem with the database" . mysql_error());
}
}

It seems to return an error message"
There was a problem with the databaseYou have an error in your SQL syntax near '(welcomemessage,pagetitle,baseurl,adminname,foote r) VALUES ('This is the welcome' at line 1

Any Ideas?