get_results($qry,ARRAY_A); $cates=$cates[0]; $tpl->assign("catename",$cates[catename]); $tpl->assign("catedescrip",$cates[description]); $tpl->assign("cateimg",$cates[img]); $tpl->assign("catesnav",$pnamelist); unset($cates,$parentids,$pnamelist); ########Sub Categories info $qry="SELECT cateid,catename FROM category WHERE parentid=$cateid ORDER BY displayorder ASC"; $subcateids=$db->get_col($qry,0); $subcatenames=$db->get_col(null,1); for($i=0;$i $subcatenames[$i]"; } $tpl->assign("subcates",$subcates); unset($subcateids,$subcatenames,$subcates); ########Products of this category info $qry="SELECT COUNT(id) FROM product WHERE cateid=$cateid"; $productcount=$db->get_col($qry,0); $productcount=$productcount[0]; $sortname=isset($_GET['sortname'])?$_GET['sortname']:"addtime"; $sorttype=isset($_GET['sorttype'])?$_GET['sorttype']:"DESC"; $qry="SELECT id,name,comments,addtime,image,tradeprice,retailcost,goodsid FROM product WHERE cateid=$cateid ORDER BY ".addslashes($sortname)." ".$sorttype; if($productcount) { require "./admin/pagenav.php"; $nav=new pagenav($qry,$productcount,$cate_products_qty); $pro_id=$db->get_col($nav->query,0); $pro_name=$db->get_col(null,1); $pro_comments=$db->get_col(null,2); $pro_addtime=$db->get_col(null,3); $pro_image=$db->get_col(null,4); $pro_tradeprice=$db->get_col(null,5); $pro_retailcost=$db->get_col(null,6); $pro_spid=$db->get_col(null,7); //if(is_array($pro_addtime)) foreach($pro_addtime as $key=>$result) $pro_addtime[$key]=date("m/d/Y",$result); if(is_array($pro_image)) foreach($pro_image as $key=>$result) { if($result) resizeimg($product_img_dir.$result,$thumb_dir.$result,75,75); } $tpl->assign("pro_id",$pro_id); $tpl->assign("pro_name",$pro_name); $tpl->assign("pro_comments",$pro_comments); //$tpl->assign("pro_addtime",$pro_addtime); $tpl->assign("pro_image",$pro_image); $tpl->assign("pro_tradeprice",$pro_tradeprice); $tpl->assign("pro_retailcost",$pro_retailcost); $tpl->assign("pro_spid",$pro_spid); //Nav $frew=""; $rew=""; $ffwd=""; $fwd=""; $tpl->assign("navinfo",$nav->show_info()); $tpl->assign("navbar",$nav->show_num_pages($frew,$rew,$ffwd,$fwd)); unset($pro_id,$pro_name,$pro_comments,$pro_addtime,$pro_image,$pro_tradeprice,$pro_retailcost,$nav); } else $tpl->assign("pro_empty",1); ###Other //Categories List Data $cachesorts = cachesorts(); $rows=get_categories(); $tpl->assign("category_rows",$rows); unset($cachesorts,$rows); //Right Column Data :specials & Adcolumn right_col(2); $tpl->assign("cateid",$cateid); /* $tpl_vars = $tpl->get_template_vars(); print_rr($tpl_vars); */ $output=$tpl->fetch("show_cate_,ahp2004.htm"); echo str_replace($tpl_imgdir_name, $tpl->template_dir.$tpl_imgdir_name,$output); ?>