View difference between Paste ID: fNPpNMG2 and zNNEJLL8
SHOW: | | - or go back to the newest paste.
1
<?php 
2
function caridusun ($keyword){
3
    $keyword = strtoupper($keyword); //maksudnya yg ini
4-
				FROM dusun a LEFT JOIN desa b on b.desa_id = a.desa_id WHERE
4+
5
				b.desa_nama as desa
6
				FROM dusun a 
7
			LEFT JOIN desa b on b.desa_id = a.desa_id WHERE
8-
	
8+
9
			dusun_kode LIKE '%$keyword%' OR
10
			dusun_nama LIKE '%$keyword%'
11
		";
12
		return  query($query);
13
}