//require_once('_lib/paging.class.php');
//s$title='How do I advertise online with the Really Useful Directory?';
$meta_description='The Really Useful Directory will shortly be launching an online listing on this website. If you have a business in North West Cardiff, North East Cardiff, Blackwood, Bargoed, Llantrisant or Caerphilly get in touch with the Really Useful Directory for details of our price plans and to register your details. If you already advertise with The Really Useful Directory you will automatically qualify for a free trial period advertising online with us! We will be in touch with more details on the types of advertising available on this website very soon.';
$meta_keywords='Really Useful Directory, free directory, directories, online directories, advertise, local directories, North West Cardiff, North East Cardiff, Blackwood, Bargoed, Llantrisant, Caerphilly.';
$where=array();
$where[]='1=1';
$where[]="(
enhanced=0 or
(enhanced=1 and expiration>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: /
if( count( $listings ) ){
foreach( $listings as $k=>$v ){
if( $v['enhanced'] ){
$description=explode("\n",$v['description']);
?>
if($description[0]){ ?>
} ?>
if($description[1]){ ?>
} ?>
if($description[2]){ ?>
} ?>
if($description[3]){ ?>
} ?>
if($description[4]){ ?>
} ?>
if($description[5]){ ?>
} ?>
Website |
Contact business |
Directions
}else{ ?>
} ?>
} ?>
}else{ ?>
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!