Hi,
I am wirting this site that submits about 100 pieces of info into a MySQL DB. I keep getting a this message:Warning: 0 is not a MySQL link index in /opt2/medicala/httpd/htdocs/patientinfoform.php3 on line 166.
I am also getting this message:
You have an error in your SQL syntax near '$30dbsll','$30dbslr','$30dbsldbin','')' at line 1
Any help would be great.
Thanks
Here is the SQL String:INSERT INTO patient (leftear_name,rightear_name,firstname,lastname,middlein,evaldate,username,dob,age,hlossinfamily,tinnitus,tinnituslocation,headtrauma,diabetic,poorhealth,eardeformity,historydrainage,suddenloss,dizziness,unilateralloss,airbonegap,cerumen,pain,historytreatment,datedesc,rac250,rac250m,rac500,rac500m,rac1k,rac1km,rac2k,rac2km,rac3k,rac3km,rac4k,rac4km,rac6k,rac6km,rac8k,rac8km,rbc250,rbc250m,rbc500,rbc500m,rbc1k,rbc1km,rbc2k,rbc2km,rbc3k,rbc3km,rbc4k,rbc4km,rbc6k,rbc6km,rbc8k,lac250,lac250m,lac500,lac500m,lac1k,lac1km,lac2k,lac2km,lac3k,lac3km,lac4k,lac4km,lac6k,lac6km,lac8k,lac8km,lbc250,lbc250m,lbc500,lbc500,lbc1k,lbc1km,lbc2k,lbc2km,lbc3k,lbc3km,lbc4k,lbc4km,lbc6k,lbc6km,lbc8k,srtl,srtr,srtbin,mcll,mclr,mclbin,ucll,uclr,uclbin,discl,discr,discbin,30dbsll,30dbslr,30dbslbin,comments) VALUES ('$leftear_name','$rightear_name','$firstname','$lastname','$middlein','$evaldate','$username','$dob','$age','$hlossfamily','$tinnitus','$tinnituslocation','$headtrauma','$diabetic','$poorhealth','$eardeformity','$historydrainage','$suddenloss','$dizziness','$unilateralloss','$airbonegap','$cerumen','$pain','$historytreatment','$datedesc','$rac250','$rac250m','$rac500','$rac500m','$rac1k','$rac1km','$rac2k','$rac2km','$rac3k','$rac3km','$rac4k','$rac4km','$rac6k','$rac6km','$rac8k','$rac8km,'$rbc250','$rbc250m','$rbc500','$rbc500m','$rbc1k','$rbc1km','$rbc2k','$rbc2km','$rbc3k','$rbc3km','$rbc4k','$rbc4km','$rbc6k','$rbc6km','$rbc8k','$lac250','$lac250m','$lac500','$lac500m','$lac1k','$lac1km','$lac2k','$lac2km','$lac3k','$lac3km','$lac4k','$lac4km','$lac6k','$lac6km','$lac8k','$lac8km','$lbc250','$lbc250m','$lbc500','$lbc500m','$lbc1k','$lbc1km','$lbc2k','$lbc2km','$lbc3k','$lbc3km','$lbc4k','$lbc4km','$lbc6k','$lbc6km','$lbc8k','$srtl','$srtr','$srtbin','$mcll','$mclr','$mclbin','$ucll','$uclr','$uclbin','$discl','$discr','$discbin','$30dbsll','$30dbslr','$30dbsldbin','$comments')" ;
