// vars are set in assign.inc
include("assign.inc");
$parent_cat_query = "SELECT cat_short FROM `cat` WHERE cat_id = '$this_parent_cat_id'";
$parent_cat_result = $db->query($parent_cat_query);
$parent_cat = $parent_cat_result->fetch();
$show = addslashes($_GET["show"]);
$cats_array = array();
$cat_array = array();
$mfg_array = array();
$cat_query = "SELECT * FROM `cat`";
if(Str::has_value($this_subcat_id)) {
$cat_query .= " WHERE cat_id = '$this_subcat_id'";
}
else {
$cat_query .= " WHERE cat_name = '$this_subcat_name'";
} // end if
$cat_query .= " LIMIT 1;";
$cat_result = $db->query($cat_query);
$cat = $cat_result->fetch();
// Product query
if($this_mfg_id) {
$add_to_query = "AND mfg.mfg_id='" . $this_mfg_id ."'";
}
if($this_subcat_id) { $search_id = $this_subcat_id; } else { $search_id = $this_parent_cat_id; }
// pagination code
$initial_prod_query = "SELECT 1 FROM `prod` LEFT JOIN prod_cat ON prod_cat.prod_id=prod.prod_id LEFT JOIN mfg ON prod.mfg_id = mfg.mfg_id WHERE cat_id='$search_id' $add_to_query AND prod_active = 1;";
$initial_prod_result = $db->query($initial_prod_query);
$initial_prod_count = $initial_prod_result->count();
$prod_limit = 15;
$total_pages = ceil($initial_prod_count / $prod_limit);
$page=1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$start_from = ($page - 1) * $prod_limit;
if($this_mfg_id) {
$add_to_query = "AND mfg.mfg_id='$this_mfg_id'";
}
if($start_from < 0) {$start_from = 0;}
$initial_subcat_id = $this_subcat_id; // determine if a subcat was sent in the URL
// end pagination code
$prod_query =
"SELECT prod_name, prod_url, prod.prod_id, prod.prod_new, mfg_name, prod.mfg_id, cat_id, prod_new_end,
(SELECT prod_img_name FROM prod_img WHERE prod_img.prod_id = prod.prod_id ORDER BY prod_img.prod_img_index LIMIT 1) AS img
FROM `prod` LEFT JOIN prod_cat ON prod_cat.prod_id=prod.prod_id LEFT JOIN mfg ON prod.mfg_id = mfg.mfg_id
WHERE cat_id='$search_id' $add_to_query AND prod_active = 1
ORDER BY mfg_name, prod_name LIMIT $start_from, $prod_limit;";
$prod_result = $db->query($prod_query);
//pagination
$mfg_query = "SELECT mfg.mfg_name, mfg.mfg_id from prod LEFT JOIN prod_cat ON prod.prod_id = prod_cat.prod_id Left JOIN mfg ON mfg.mfg_id = prod.mfg_id WHERE `cat_id` LIKE '$this_parent_cat_id' and prod.prod_active = 1 GROUP BY mfg.mfg_id;";
$mfg_result = $db->query($mfg_query);
while($mfg_row = $mfg_result->fetch()) {
if($mfg_row->mfg_name) {
$mfg_array[$mfg_row->mfg_id] = $mfg_row->mfg_name;
}
}
// echo queries
// echo "initial " . $initial_prod_query ."
";
// echo "prod " . $prod_query ."
";
// // build mfg array
// echo "mfg " . $mfg_query ."
";
// echo "mfg count: " . $mfg_result->count();
// print_r($mfg_array);
// if($cat_result->count() == 0) {
// redirect("index.htm");
// } // end if
include("head.inc");
include("side_menu.inc");
include("menu_bar.inc");
include("breadcrumbs.inc");
?>