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!
Web design by