SQL Syntax error ...
I read the previous post and followed the instructions, but they did not solve my issue.
I had created all the customized front end pages, as well as the back end pages and had everything working perfectly while they were hosted on the Yahoo business servers. However, we recently migrated to GoDaddy.com (PHP 5, MySQL Server version: 5.0.91) and now that the pages have fully propagated, I am getting a SQL syntax error when I try to view any pages built by DataAssist that pull data into the page.
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 'condition, description, mileage, stocknumber, price, status FROM usedbikes WHERE' at line 1
I get no errors on other pages I built that are pulling dynamically to list the current inventory (ex: ducati_.php), however, when I try to view any of the admin pages, I get the error.
Today, I started from scratch and completely rebuilt all the pages again, using a fresh install of DataAssist, and uploaded all the pages to my server - and I still get the same syntax error message.
URL: usedbikes_Search.php views with no probs (no data pulled)
usedbikes_Results.php gets the syntax error