syntax error

[Dillenger]

I get this error when I run my script:

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 'show = 'on' WHERE name = victoria' at line 1 UPDATE areas SET show = 'on' WHERE name = 'victoria'

$SQL5 = "UPDATE areas SET";
		$SQL5 = $SQL5 . " show = 'on' ";
		$SQL5 = $SQL5 . " WHERE name = '$area' ";
		$result34 = mysql_db_query($db,"$SQL5",$connect);
		if (!$result34) {
		echo("ERROR: " . mysql_error() . "\n$SQL5\n");
		}

Whats wrong with this code?

[danw]

        @mysql_connect($connect);
        mysql_select_db($db);
        $sql5 = "UPDATE areas SET show='on' WHERE name='$area'";
        $result34 = mysql_query($sql5); 
        if (!$result34) { 
        echo("ERROR: " . mysql_error() . "\n$sql5\n"); 
        mysql_close();
        }

[Dillenger]

tried that, still doesn't work... is it because i have another sql fuction before that? I have this

$SQL3 = " INSERT INTO southpermits_data ";
		$SQL3 = $SQL3 . "(date, area, owner, owner_address, owner_city, owner_postalcode1, owner_postalcode2, owner_phonenumber1, owner_phonenumber2, owner_phonenumber3, project_address, project_type, project_type2, amount, contractor, contractor_address, contractor_city, contractor_postalcode1, contractor_postalcode2, contractor_phonenumber1, contractor_phonenumber2, contractor_phonenumber3, published) VALUES ";
		$SQL3 = $SQL3 . " ('$date', '$area', '$owner', '$owner_address', '$owner_city', '$owner_postalcode1', '$owner_postalcode2', '$owner_phonenumber1', '$owner_phonenumber2', '$owner_phonenumber3', '$project_address', '$project_type', '$project_type2', '$amount', '$contractor', '$contractor_address', '$contractor_city', '$contractor_postalcode1', '$contractor_postalcode2', '$contractor_phonenumber1', '$contractor_phonenumber2', '$contractor_phonenumber3', '$published')";
		$result3 = mysql_db_query($db,"$SQL3",$connect);
		if (!$result3) {
		echo("ERROR: " . mysql_error() . "\n$SQL3\n");
		}else{
		echo "<font color=#990000><strong>New data has been added to the database.</stong></font>";
		}