Hello, I have this PHP code which is supposed to update my database fields but I get this error
&list=You have an error in your SQL syntax near 'group=,ttime=,scr1=,scr2=,scr3=,scr4=,scr5=,scr6=,scr7=,scr8=,scr9=,scr10=,scr11' at line 1
Here is the PHP code
$query = "UPDATE player SET fname='$fname',lname='$lname',town='$town',group=$group,ttime=$ttime,scr1=$scr1,scr2=$scr2,scr3=$scr3,scr4=$scr4,scr5=$scr5,scr6=$scr6,scr7=$scr7,scr8=$scr8,scr9=$scr9,scr10=$scr10,scr11=$scr11,scr12=$scr12,scr13=$scr13,scr14=$scr14,scr15=$scr15,scr16=$scr16,scr17=$scr17,scr18=$scr18,tout=$tout,tin=$tin,ttl=$ttl,acs=$acs,egs=$egs,bds=$bds,prs=$prs,bgs=$bgs,dbgs=$dbgs,otr=$otr,sscore='$sscore',cscore='$cscore',chole=$chole,shole=$shole WHERE playerID=$playerID";
/ Execute query /
$result = mysql_query($query)
or die("&list=" . mysql_error());
Can someone tell me why this is not working?
The database is set to accept null fields so I dont understand the error.
Thanks Searcher
