query('SELECT COUNT(DISTINCT(p.propid)) as totrec FROM property p WHERE '.$propStatusCondi.' '.$extra_condi); $db->next_row(); $totRecord=$db->RECORD['totrec']; $db->free(); if($totRecord > 0) { $categoryName='Snow Skiing'; // navigation class include_once 'include/class.paging.php'; $paging=new paging(); $paging->TotalResults = $totRecord; $paging->queryStr=$qryStr; $PageArray=$paging->InfoArray(); $navigation_listing=$PageArray['RESULTS']; $navigation=$paging->displayPages(); $propQry='SELECT DISTINCT(p.propid),p.category_id,p.people_sleep,p.bedrooms,p.bathrooms,p.children,p.airport,p.features,p.pets,p.smoke, p.wheelchair,p.prop_title,p.property_type,prop_date,display_calender,other_url_calender,is_feature FROM property p LEFT JOIN category ON (p.category_id=category.id) WHERE '.$propStatusCondi.' '.$extra_condi; include_once 'include/propertyList.class.php'; $propListing = new propertyListing($propQry); $sortCol=$propListing->sortCol; $propertyListing = $propListing->displayPropertyList(); include_once 'include/header.php'; require_once 'summary.php'; } else { include_once 'include/header.php'; include_once 'noresult.php'; } include_once("include/footer.php"); ?>