".$cID; //exit; if(isSet($_GET['cat_id'])) { $cID = $_GET['cat_id']; } if(!empty($_GET['page'])){ $page = (int)$_GET['page']; }else{ $page = 1; } $limit = LIMIT_CLASSIFIED; $start = ($page - 1) * $limit; $sql_classified = "SELECT c.*, ct.cat_url_name FROM tbl_classified c, tbl_classified_to_categories cc , tbl_categories ct WHERE cc.categories_id='$cID' and cc.classified_id=c.classified_id and ct.categories_id=cc.categories_id and c.status='1' ORDER BY premium_listing desc, c.classified_id desc"; //echo $sql_classified; $result_classified_rows = mysql_query($sql_classified) or die(mysql_error(). " " . mysql_errno()); $tot_rows = mysql_num_rows($result_classified_rows); mysql_free_result($result_classified_rows); //$pagelinks = paginate($limit, $tot_rows); /////////////////////////////////////////////////////////// $thispage = "index.php?cat_id=$_GET[cat_id]" ; $thispage =$_SERVER['REQUEST_URI']; if(empty($_GET['page'])) { $thispage .="index-".$page.".php"; } $pos = "/index-".$page.".php"; $pagelinks= seo_paginate($limit, $tot_rows, $thispage, $pos); ////////////////////////////////////////////////////////////////// $sql_classified .= " LIMIT $start, $limit"; $result_classified = mysql_query($sql_classified) or die(DB_QUERY_ERROR); if($cID>0) { $categories_query = mysql_query("select cc.* from tbl_categories cc where cc.categories_id = '" . (int)$cID. "'"); $rows_fetch = mysql_fetch_array($categories_query); $page_title=$rows_fetch['page_title'] . ' - ' . STORE_NAME; $page_description=$rows_fetch['page_description'] . ' - ' . STORE_NAME; $page_keywords=$rows_fetch['page_keywords'] . ' - ' . STORE_NAME; }else{ $page_title = STORE_NAME; $page_description = STORE_NAME; $page_keywords = STORE_NAME; } ?> <?echo $page_title;?>
     
0) { while($subcat_row = mysql_fetch_assoc($result_categories_right)) { $subcat_array[] = $subcat_row['categories_id']; } if(is_array($subcat_array) && !empty($subcat_array)) { $subcat_ids = implode(",",$subcat_array); } } if(!empty($subcat_ids)) { $sql_classified_sub_cat = "SELECT c.*, ct.cat_url_name FROM tbl_classified c, tbl_classified_to_categories cc, tbl_categories ct WHERE cc.categories_id IN($subcat_ids) and c.classified_id=cc.classified_id and cc.categories_id=ct.categories_id and c.status=1 ORDER BY c.classified_id desc Limit 0,30"; $result_classified_subcat = mysql_query($sql_classified_sub_cat) or die(mysql_error(). " " . mysql_errno()); while ($rows_classified1 = mysql_fetch_array($result_classified_subcat)) { ?>