Thanks Ray. That did take care of the error. After changing, I received an SQL syntax error - after changing the Debug setting to true in the queryobj.php and rsobj.php files, I get the following information:
SELECT * FROM subcategories WHERE SubCatID = ?
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 '? LIMIT 1' at line 1
I believe it refers to the following code:
$WADAproducts = new WA_MySQLi_RS("WADAproducts",$Amiganien_DB_i,0);
$WADAproducts->setQuery("SELECT * FROM products WHERE ProductCategoryID = ? AND ProductStore LIKE '%%NA%%' OR ProductSubCatID = ? AND ProductStore LIKE '%%NA%%' OR ProductSubCat2ID = ? AND ProductStore LIKE '%%NA%%' ORDER BY ProductPrice ASC");
so it looks like that for example "WHERE ProductCategoryID = %s" was changed to "WHERE ProductCategoryID = ?" throughout the code on the page. Is the "?" correct? I changed the ? to %s but with no affect.
Thanks a lot.
Best,
Joerg
