filters
Eric,
It sees that this sql query is not filtering on itemcatid, is this where the problem is?
$colname_bnbproducts = "-1";
if (isset($_POST['ItemCatID'])) {
$colname_bnbproducts = $_POST['ItemCatID'];
}
$colname_test = "-1";
if (isset($_GET['ItemCatID'])) {
$colname_test = $_GET['ItemCatID'];
}
mysql_select_db($database_Barks, $Barks);
$query_test = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemPrice, ItemWeight FROM items WHERE ItemCatID = 3 ORDER BY ItemCatID ASC";
$test = mysql_query($query_test, $Barks) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
$query_test = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemPrice, ItemWeight FROM items WHERE ItemCatID = 3";
$test = mysql_query($query_test, $Barks) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
$query_test = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemPrice, ItemWeight FROM items WHERE ItemCatID = ItemCatID";
$test = mysql_query($query_test, $Barks) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
$query_test = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemPrice, ItemWeight FROM items WHERE ItemCatID = ItemCatID";
$test = mysql_query($query_test, $Barks) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
$query_test = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemPrice, ItemWeight FROM items WHERE ItemCatID = ItemCatID";
$test = mysql_query($query_test, $Barks) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);