Getting error "There is an error in your SQL syntax."

The message is not very helpful I know, but I cannot see why I am getting it.I have rebuilt the file several times to no avail. I have copied a file that carries out an identical function, amended it to take into account the difference in table and field names. That too produces the error.
I am a newby to this so please bear with me. I have created this site using tutorials from Adobe and your web site tutorials.
Attached are two files which as far as I can see are identical (apart for the obvious need for different table and field names). One works, the other doesn't.
I have looked at the SQL database and that too seem OK.

I have spent hours on this so would appreciate any help you can offer. Thank you.

You can turn on debug in the queryobj.php and rsobj.php file and it will give you the true error. It is turned off by default to prevent too much information for would-be hackers.

In this case the issue is that you have a column named 'date' which is a reserved word in SQL. I'd rename that column to cg_date and that should solve it.

Thank you Ray, both for the general (re debug) and the specific (date being a reserved word) answers.That explains why all the other sections of the Terrier worked and this one didn't. For some reason I used date_recorded for all the others, so of course they worked!

Ian

Good day Ray.
You mentioned in a reply above that I can switch on debug in the queryobj.php and rsobj.php files. I had a look at these files but am not certain which lines to change. Could you explain what line(s) to change please. I have hit another SQL error and it would be a better learning experience if I could try and solve it myself.
Many thanks.
Ian

In the latest version of those files you will find this line near the top:
$this->Debug = false;

just update that line to true and upload it.

Thanks Ray - sorry for delay in acknowledging your help.