singlerec("select * from category where id='$categoryid5'"); $scat=$db->singlerec("select * from category where id='$scategoryid'"); $categorysearch1=$cat['randuniq']; $scategorysearch1=$scat['randuniq']; $cat1=($categorysearch1)?"categoryid='$categorysearch1' and":""; $scat1=($scategorysearch1)?"subcategoryid='$scategorysearch1' and":""; $search1=($search)?"business_title LIKE '%$search%' and":""; $amountsearch1=($amountsearch)?"actual_price <= '$amountsearch' and":""; $stu=$cat1." ".$scat1." ".$search1." ".$amountsearch1; $sql="select * from product where $stu active_status='1' order by id desc"; }else{ $sql="select * from product where active_status='1' order by id desc"; } $cat2=($cat)?"$cat[name] category":""; $scat2=($scat)?"$scat[name] category":""; $strGet = ""; $pagePer =9; $product=$db->get_all_assoc(getPagingQuery1($sql, $pagePer , $strGet)); //$product=$db->get_all($sql); /* if(empty($product)){ echo "

    No Product Avaliable in this $search ".$cat2."".$scat2."

    "; } */ $i=300; if(count($product) > 0){ foreach($product as $pro){ $pid=$pro['id']; $kit_status=$pro['kit_status']; $likecheck=$db->check3column('wishlist','userid',$userid,'prod_id',$pid,'status','0'); $wishlist=($likecheck)?"link-wishlist":"link-wishlist1"; ?>