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();
?>

It is getting the tables from the server defined as the Testing Server in your Dreamweaver site definition. You probably have that pointed to localhost which has a different database setup.

Okay, I am not sure what would have been local host. The root path in the image below I removed from the testing server and I recreated the connection and all tables now now. However, I'm getting an inaccessible usr folder created each time I connect to the site in DW.

This is an odd one... My guess is that you have multiple usr folders with different case on the remote server. You may need to go in with another FTP program and delete the duplicate folders and make sure the case on the remote server is the same as your local directory.