I am building a Web app that allows users to submit a bunch of fields(around 100)
and I keep getting this error:
You have an error in your SQL syntax near '171','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32',' at line 1
Any help would be great.
Here is my SQL string:
$query = "INSERT INTO patient (leftear_name,";
$query .= "rightear_name,firstname,middlein,lastname,evaldate,username,dob";
$query .= ",age,hlossinfamily,tinnitus,tinnituslocation,headtrauma,diabetic,";
$query .= "poorhealth,eardeformity,historydrainage,suddenloss,dizziness,unilateralloss,";
$query .= "airbonegap,cerumen,pain,historytreatment,datedesc,rac250,rac250m,rac500,rac500m,";
$query .= "rac1k,rac1km,rac2k,rac2km,rac3k,rac3km,rac4k,rac4km,rac6k,rac6km,rac8k,rac8km,";
$query .= "rbc250,rbc250m,rbc500,rbc500m,rbc1k,rbc1km,rbc2k,rbc2km,rbc3k,rbc3km,rbc4k,rbc4km,";
$query .= "rbc6k,rbc6km,rbc8k,lac250,lac250m,lac500,lac500m,lac1k,lac1km,lac2k,lac2km,lac3k,";
$query .= "lac3km,lac4k,lac4km,lac6k,lac6km,lac8k,lac8km,lbc250,lbc250m,lbc500,lbc500m,lbc1k,";
$query .= "lbc1km,lbc2k,lbc2km,lbc3k,lbc3km,lbc4k,lbc4km,lbc6k,lbc6km,lbc8k,srtl,srtr,srtbin,";
$query .= "mcll,mclr,mclbin,ucll,uclr,uclbin,discl,discr,discbin,30dbsll,30dbslr,30dbslbin,comments)";
$query .= " VALUES ('$leftear_name','$rightear_name','$firstname','$lastname','$middlein','$evaldate',";
$query .= "'$username','$dob','$age','$hlossfamily','$tinnitus','$tinnituslocation','$headtrauma',";
$query .= "'$diabetic','$poorhealth','$eardeformity','$historydrainage','$suddenloss','$dizziness',";
$query .= "'$unilateralloss','$airbonegap','$cerumen','$pain','$historytreatment','$datedesc',";
$query .= "'$rac250','$rac250m','$rac500','$rac500m','$rac1k','$rac1km','$rac2k','$rac2km','$rac3k',";
$query .= "'$rac3km','$rac4k','$rac4km','$rac6k','$rac6km','$rac8k','$rac8km,'$rbc250','$rbc250m',";
$query .= "'$rbc500','$rbc500m','$rbc1k','$rbc1km','$rbc2k','$rbc2km','$rbc3k','$rbc3km','$rbc4k',";
$query .= "'$rbc4km','$rbc6k','$rbc6km','$rbc8k','$lac250','$lac250m','$lac500','$lac500m','$lac1k','$lac1km',";
$query .= "'$lac2k','$lac2km','$lac3k','$lac3km','$lac4k','$lac4km','$lac6k','$lac6km','$lac8k','$lac8km',";
$query .= "'$lbc250','$lbc250m','$lbc500','$lbc500m','$lbc1k','$lbc1km','$lbc2k','$lbc2km','$lbc3k',";
$query .= "'$lbc3km','$lbc4k','$lbc4km','$lbc6k','$lbc6km','$lbc8k','$srtl','$srtr','$srtbin','$mcll',";
$query .= "'$mclr','$mclbin','$ucll','$uclr','$uclbin','$discl','$discr','$discbin',";
$query .= "'$a30dbsll','$a30dbslr','$a30dbsldbin','$comments')" ;
