$sellist=mysql_query("select a.prod_name,a.list_image,a.category, a.subcategory, a.description, a.keywords, b.catfolder from cms_listing_master a, cms_category_master b where a.subcategory=b.subcategory and a.category=b.category and a.comp_id='$comp_id' and (a.category like '%travel%' or a.category like '%hotel%') group by a.category order by a.category limit 0,20") or die(mysql_error()) ;
while($rk=mysql_fetch_array($sellist)){
$cats=$rk['category'];
$scats=$rk['subcategory'];
$descpt=$rk['description'];
$catfolder=$rk['catfolder'];
$prod_name=$rk['prod_name'];
$list_image=$rk['list_image'];
$caturl = str_replace("(", "", $scats);
$caturl = str_replace(")", "", $caturl);
$caturl = str_replace("'", "", $caturl);
$caturl = str_replace("\"", "", $caturl);
$caturl = str_replace("/", "", $caturl);
$caturl = str_replace(",", "", $caturl);
$caturl = str_replace("&", "", $caturl);
$caturl = str_replace(" and ", " ", $caturl);
$caturl = str_replace(" other ", " ", $caturl);
$caturl = str_replace(" And ", " ", $caturl);
$caturl = str_replace(" Other ", " ", $caturl);
$caturl = str_replace("-", "", $caturl);
$caturl = str_replace(" ", "-", $caturl);
$caturl = str_replace("-----", "-", $caturl);
$caturl = str_replace("----", "-", $caturl);
$caturl = str_replace("---", "-", $caturl);
$caturl = str_replace("--", "-", $caturl);
$caturl = strtolower($caturl);
?>
»
=$cats;?>
»
=$scats;?>
}
?>
»
View all categories