CURDATE()) ) "; if($_GET['service']){ $service = sql_query("SELECT id FROM services WHERE name='".escape($_GET['service'])."'", 1); $where[]="service='".escape($service['id'])."'"; } if($_GET['company']){ $where[]="company LIKE '".escape($_GET['company'])."%'"; } $postcode=trim(strtoupper($_GET['area'])); if(is_postcode($postcode)){ $grids=calc_grids( $postcode ); }elseif( $_GET['area'] ){ $where[]=" ( town='".escape($_GET['area'])."' or city='".escape($_GET['area'])."' ) "; } $where_str=''; foreach($where as $w){ $where_str.=$w." AND "; } $where_str=substr($where_str,0,-4); if( $grids ){ $query="SELECT *, ROUND( ( SQRT( (n-".$grids[0].") * (n-".$grids[0].") + (e-".$grids[1].") * (e-".$grids[1].") ) ) * 0.000621371192 ) AS distance FROM listings WHERE $where_str "; $p = new paging( $query, 10, 'enhanced DESC, distance, company', 0, NULL, 10 ); }else{ $query="SELECT * FROM listings WHERE $where_str "; $p = new paging( $query, 10, 'enhanced DESC, company', 0, NULL, 10 ); } $paging=$p->get_paging(); $results=$p->get_results(); $listings=sql_query($p->query); ?>

 

You searched for: /

$v ){ if( $v['enhanced'] ){ $description=explode("\n",$v['description']); ?>

We're sorry but no results were found for your search

If you'd like to list your business under this category why not get in touch?

Business not listed with RUDirect? Get a free business listing today!