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 | } |