error your SQL syntax
The following code is generated by eCart. and crashes with 'You have an error in your SQL sytax. It has affected two sites that were previously working. They both crashed after templates were updated containing changes in unrelated code.
The page is an order confirmation and runs perfectly if this section is commented out, though obvoiusly doesn't do what was intended.
Another problem with this is that it will only run on the local server as root even thouigh the user a/c is valid and tested in MySQL Workbench. This is a serious reputational and financial problem and I would appreciate your early attention
You will also see in the attached code some hacks going round in circles with session variables to try to save the order number correctly. I gave up trying to do it by the book as I got nowhere and every saved order had the number 400007. Christ only knows where that came from but it consistently appeared. Pragmatism overuled purity.
I'm in your hands.
Malcolm