Conveniently located near an array of attractions in Mantenga, the Happy Valley Hotel offers affordable accommodation for business and pleasure and is ideal for tours and coaches. All bedrooms en-suite, well furnished each with telephone, fridge, coffee machine and M-Net.
getCfg( 'shownoauth' );
$now = date( 'Y-m-d H:i:s', time()+$mosConfig_offset*60*60 );
$nullDate = $database->getNullDate();
$limit = ' limit 5';
$query = "SELECT a.id"
."\n FROM #__content AS a"
."\n INNER JOIN #__categories AS b ON b.id = a.catid"
."\n WHERE a.state = 1"
. ( $noauth ? "\n AND a.access <= $my->gid AND b.access <= $my->gid" : '' )
."\n AND (a.publish_up = '$nullDate' OR a.publish_up <= '$now' ) "
."\n AND (a.publish_down = '$nullDate' OR a.publish_down >= '$now' )"
."\n AND catid = 626"
."\n ORDER BY a.ordering"
."\n $limit"
;
$database->setQuery( $query );
$rows = $database->loadResultArray();
$numrows = count( $rows );
?>
Conveniently located near an array of attractions in Mantenga, the Happy Valley Hotel offers affordable accommodation for business and pleasure and is ideal for tours and coaches. All bedrooms en-suite, well furnished each with telephone, fridge, coffee machine and M-Net.
