p1plyr is the name associated with 2 radio buttons on a form. If either is checked, the command updates the form as intended. BUT, if neither are checked it returns the message below. My thoughts were that if neither were selected, the command would update the table with "" or the default which is 0.
Any help, as always, will be greatly appreciated.
$query="UPDATE tbl_results SET sUKRESp1plyr=$arVals[p1plyr] WHERE sUKRESusername = '$sesusername' AND sUKRESseasonend = 2007 AND sUKRESmatch = $_SESSION[REQmatch]"; //iPuserid=$userid
$result = mysql_query($query) or die("Invalid query: " . mysql_error() . "<br><br>". $query);
Invalid query: 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 'WHERE sUKRESusername = 'yyyy' AND sUKRESseasonend = 2007 AND sU
UPDATE tbl_uk_soc_results SET sUKRESp1plyr= WHERE sUKRESusername = 'yyyy' AND sUKRESseasonend = 2007 AND sUKRESmatch = 1