connections not showing all tables
HI Ray, I have got a search page functioning I think but it is showing no results. When I look at the DB connections, it is not showing all tables. I deleted the WA connection and redid it but not all the tables are showing. Navicat shows all the tables. Right now, it seems that the WA connection is using the unpopulated table Products, when I don't even have a table with that name. My populated table is products with lowercase. However it is not seen. I will try changing the name in Navicat to match, but the queries are set to that table
<?php
if (isset($_POST["Delete"]) || isset($_POST["Delete_x"])) {
$DeleteQuery = new WA_MySQLi_Query($DealersSupplyCo);
$DeleteQuery->Action = "delete";
$DeleteQuery->Table = "products";
$DeleteQuery->addFilter("ProductID", "=", "d", "".((isset($_POST["WADADeleteRecordID"]))?$_POST["WADADeleteRecordID"]:"") ."");
$DeleteQuery->execute();
$DeleteGoTo = "products_results.php?ProductID=".((isset($_POST["WADADeleteRecordID"]))?$_POST["WADADeleteRecordID"]:"") ."";
if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
$DeleteQuery->redirect($DeleteGoTo);
}
?>
<?php
$WADAproducts_details = new WA_MySQLi_RS("WADAproducts_details",$DealersSupplyCo,1);
$WADAproducts_details->setQuery("SELECT ProductID, ProductName, ProductImage, ProductSKU, CatalogMain, Catalog3, Catalog2, WholesalePrice, ProductShortDesc, ProductLongDesc FROM products WHERE products.ProductID = ?");
$WADAproducts_details->bindParam("i", "".($_GET['ProductID']) ."", "-1"); //ParamProductID
$WADAproducts_details->execute();
?>