Thanks Ray,
I did the changes but I believe that somehow the automatic migration from mysql to mysqli might have screwed up a couple of things. For example, the automatic change of the recordset WADAproducts migrated to:
<?php
$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");
$WADAproducts->bindParam("i", "".(isset($_GET['ProductCategoryID'])?$_GET['ProductCategoryID']:"") ."", "-1"); //ProductCategory
$WADAproducts->bindParam("i", "".(isset($_GET['ProductCategory2ID'])?$_GET['ProductCategory2ID']:"") ."", "-1"); //ProductCategory2
$WADAproducts->bindParam("i", "".(isset($_GET['ProductSubCatID'])?$_GET['ProductSubCatID']:"") ."", "-1"); //subcategory2
$WADAproducts->execute();
?>
Looking at the line:
$WADAproducts->bindParam("i", "".(isset($_GET['ProductCategory2ID'])?$_GET['ProductCategory2ID']:"") ."", "-1"); //ProductCategory2
a ProductCategory2ID is showing up but there is no Category2 in the database and instead, there is a SubCat2 in the database which does not appear in the migrated recordset.
I thought that might be a reason why for example all the navigation links that refer to the SubCat2ID don't display the products from the database anymore.
So I tried changing the line to
$WADAproducts->bindParam("i", "".(isset($_GET['ProductSubCat2ID'])?$_GET['ProductSubCat2ID']:"") ."", "-1"); //ProductCategory2
not sure whether this would be correct or not because it did not fix the problem with the navigation.
However, besides the problem with the navigation links not showing products with a SubCat2ID, with the changes you suggested I now have the following errors in the products_detail.php page:
Notice: Undefined index: eCart1_1_size_Add in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php on line 71
Notice: Undefined index: eCart1_1_ID_Add in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php on line 72
Notice: Undefined index: eCart1_1_size_Add in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php on line 73
Notice: Undefined index: eCart1_1_ID_Add in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php on line 74
Fatal error: Uncaught Error: Call to undefined function mysql_escape_string() in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php:23 Stack trace: #0 /Applications/MAMP/htdocs/NavariniUSA/products_detail.php(96): GetSQLValueString('', 'int') #1 {main} thrown in /Applications/MAMP/htdocs/NavariniUSA/products_detail.php on line 23