Issue with insert record

I have an issue with an insert record script on a page I am building. I have built quite a few using the mSQLi scripts and never had this trouble before. When the form is filled in I get a simple error that says "There is an error in your SQL syntax."

I have been on to tech support on my web host, who have confirmed there is nothing wrong with the settings, and the php error log is not showing any further information as to why it is happening.

I've attached the file in question, and given a link in private to the web page. I have also attached another version of the file that includes recaptcha - it also isbn;t working even though it should, but that gives a different error message, and I thought it might be useful in spotting what's going wrong :)

You should be able to go into your queryobj.php file and change the debug setting to true. That will show the actual error message when inserting instead of the general one you are seeing now. That may help in tracking it down.

yes I did that, and now have the error on screen. I'm still not sure what I have done wrong through.

INSERT INTO INQUIRIES (ID, NAME, ADDRESS, CONTACT_EMAIL, CONTACT_PHONE, HOTEL STAY, DATES_REQUIRED, VEHICLES_REQUIRED, COMMENTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

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 'STAY, DATES_REQUIRED, VEHICLES_REQUIRED, COMMENTS) VALUES (?, ?, ?, ?, ?, ?, ?, ' at line 1

The issue is with the space in the column name. The current version of MySQLi doesn't work with spaces in column names. You can either change the column name to use an underscore, or manually update the code and encapsulate the column name with single quotes to fix the issue for now.