New problem with multi checkbox update
I am trying to update multiple checkboxes but keep getting an error. It is a very similar scenario to the problem I had before (in this post)
I have a single table update that updates information on a car and 5 multi table updates that update specific features a car has (interior features, exterior features, entertainment features, safety features and other features) all on one page. The multi updates are all checkboxes.
I have created 5 recordsets to display all the information in each of the tables. I have created another 5 recordsets to pull in the records that match for that car ID.
I have created relational tables for each of the 5 updates and added a loop around the checkbox.
I have check my code against the previous (working version) I created but I just get this error:
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 'Desc FROM cardesc_entertain WHERE `cartypeID`=1322 ORDER BY Desc' at line 1.
I have attached the file.