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