Show products where status = 10
I need to show only products where status is NOT 10 and then created a similiar SQL where status = 10.
<?php
$maxRows_WADAproducts = 100;
$pageNum_WADAproducts = 0;
if (isset($_GET['pageNum_WADAproducts'])) {
$pageNum_WADAproducts = $_GET['pageNum_WADAproducts'];
}
$startRow_WADAproducts = $pageNum_WADAproducts * $maxRows_WADAproducts;
$IDParam_WADAproducts = "1";
if (isset($_GET['ProductID'])) {
$IDParam_WADAproducts = $_GET['ProductID'];
}
mysql_select_db($database_homesteadproducts, $homesteadproducts);
$query_WADAproducts = sprintf("SELECT * FROM products WHERE ProductStatus <> 10, INNER JOIN productsubcategories ON products.ProductCatID = ProdSubCatID ORDER BY ProdSubCatID, ProductSortOrder ASC", GetSQLValueString($IDParam_WADAproducts, "int"));
$query_limit_WADAproducts = sprintf("%s LIMIT %d, %d", $query_WADAproducts, $startRow_WADAproducts, $maxRows_WADAproducts);
$WADAproducts = mysql_query($query_limit_WADAproducts, $homesteadproducts) or die(mysql_error());
$row_WADAproducts = mysql_fetch_assoc($WADAproducts);
if (isset($_GET['totalRows_WADAproducts'])) {
$totalRows_WADAproducts = $_GET['totalRows_WADAproducts'];
} else {
$all_WADAproducts = mysql_query($query_WADAproducts);
$totalRows_WADAproducts = mysql_num_rows($all_WADAproducts);
}
$totalPages_WADAproducts = ceil($totalRows_WADAproducts/$maxRows_WADAproducts)-1;
?>