fungsi

function search_detail($uri,$alias)
{

$sql="SELECT q.alias,q.description
FROM ds_fasilitas q
WHERE q.alias = '%{$alias}%'
UNION
SELECT
w.title AS title,
w.alias AS alias,
w.menu_description AS description
FROM ds_hunian w
WHERE w.alias = '%{$alias}%'

UNION
SELECT
e.title AS title,
e.alias AS alias,
e.menu_description AS description
FROM ds_hunian_submenu e
WHERE e.alias = '%{$alias}%'

UNION
SELECT
r.title AS title,
r.alias AS alias,
r.proyek_description AS description
FROM ds_proyek r
WHERE r.alias = '%{$alias}%'

UNION
SELECT
t.title AS title,
t.alias AS alias,
t.subproyek_description AS description
FROM ds_proyek_sub t
WHERE t.alias = '%{$alias}%'

UNION
SELECT
y.title AS title,
y.alias AS alias,
y.description AS description
FROM ds_warta_acara y
WHERE y.alias = '%{$alias}%'

UNION
SELECT
u.title AS title,
u.alias AS alias,
u.description AS description
FROM ds_prestasi_apresiasi u
WHERE u.alias ='%{$alias}%'

LIMIT {$uri}";
$query=$this->db->query($sql);
$result = ($query->num_rows()>0)? $query->row_array():FALSE;
if($resut==false){ error_log("\nquery tidak ketemu:\$sql",3,"error.log"); } //kalau false coba cek ada tidak file error.log di folder utama..  trus baca apa sql nya disana
return $result
}