My interactive elearning site experiences an error when students answer quiz questions, but only when using Google Chrome or the Mozilla Firefox updated version. The error is related to these browser versions. It works fine in Internet Explorer and works fine in the earlier version of Firefox. The website runs on php and mysql. The program was developed in the version of php and mysql that was in use on August of 2006. The syntax needs to be updated to work on these newer browser versions.
This is a copy of the error a student receives when they answer a question on a quiz. (internal error 1064: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 '' at line 1)
Once the code is updated and the problem fixed, I need it applied to three other websites that have the same scrip and the same problem.
I included four files as attachments with code where I think the problem may be. The problem is likely in [url removed, login to view] because that is the file in use when the problem occurs.