There is an error in your SQL syntax on live server

Help! I am trying to test my work on my live server (Hostgator) and I am getting the following error message

"There is an error in your SQL syntax"

The funny thing is, my development website on my local machine (Windows with WAMP) works great. Can you please take a look at my sample index page that I am trying to test and let me know what is wrong?

Thank you,
Robert

Open your rsobj.php page and change the debug setting to true near the top of the file. That should show you a better error message.

Ray, I opened the rsobj.php and did not see a debug setting. Can you please be more specific as to which line I need to change?

Thanks,
Robert

I've attached the current beta version of the rsobj.php file. The debug setting is on line 11

The debug worked! Here is the error message I am getting:

SELECT SQL_CALC_FOUND_ROWS * FROM products WHERE ProductID = -1 ORDER BY ProductID ASC LIMIT 0,1

Unknown column 'ProductID' in 'where clause'

Any reason why the page is working on my WAMP server but not my live Hostgator server?

Robert

That means your products table doesn't have a column named ProductID on your live server. Make sure the database table was created properly on the live server.

What an idiot I am! LOL! I made some adjustments to my products table structure and forgot to change the ProductID field to ProdID like it is on my live server. Once I changed the name back from ProductID to ProdID the page worked fine. Thanks for the help!

Robert