I keep getting 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 '1' at line 1. I honestly don't see where i might have gone wrong
case "Update":
if(isset($firstname, $lastname, $phone, $address, $city, $state, $zip))
{
mysql_select_db("webuser23", $dbc);
$query = ("UPDATE customers SET firstname = '$firstname' OR lastname = '$lastname' OR phone = '$phone' OR address = '$address' OR city = '$city' OR state = '$state' OR zip = '$zip' WHERE customernumber = '$id' ");
$result = mysql_query($query);
if (!mysql_query($result, $dbc))
{
die('Error: ' . mysql_error());
}
echo "1 record updated";
mysql_close($dbc);