PHP Indonesia - Facebook: [ASK] Mas, aku punya 2 Query SQL seperti ini : $sq...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

[ASK] Mas, aku punya 2 Query SQL seperti ini : $sq... Jul 26th 2013, 02:33, by Ermawan Ermawan 2:33am Jul 26 [ASK] Mas, aku punya 2 Query SQL seperti ini : $sql1st = "SELECT * FROM unit_kerja WHERE unit_parent = ? ORDER BY unit_nm ASC"; $sql2nd = "SELECT * FROM unit_kerja WHERE unit_cd LIKE ? AND unit_nm LIKE ? LIMIT ?, ?"; ---------------------------------------------------------------------------------------------- Terus mau tak gabungin, bener gak jadi begini ? $sql3rd = "SELECT * FROM unit_kerja WHERE (unit_parent = ?) unit_cd LIKE ? AND unit_nm LIKE ? ORDER BY unit_nm ASC LIMIT ?, ?"; --------------------------------------------------------------------------------------------- Bingungnya dibagian WHERE ampe 3 biji gitu je mas :D Mohon solusinya :D Yunas 'Abdul' Aziz 2:40am Jul 26 SELECT * FROM unit_kerja WHERE unit_parent = ? AND unit_cd LIKE ? AND unit_nm LIKE ? ORDER BY unit_nm LIMIT ?, ? kalo gitu bisa ga? Ermawan 2:43am Jul 26 kalau pakek union gimana ya mas Yunas 'Abdul' Aziz 2:51am Jul 26 itu sql pertama sama kedua beda tabel atau hanya 1 tabel yaa??? sebenarnya setahu saya fungsi UNION itu untuk menggabungkan 2 (atau 2 tabel) query dengan catatan strukturnya harus sama., jika hanya satu tabel menurut saya tidak usah memakai UNION, ini contoh penggunaan UNION : SELECT * FROM unit_kerja WHERE unit_parent = ? UNION SELECT * FROM unit_kerja WHERE unit_cd LIKE ? AND unit_nm LIKE ? ORDER BY unit_nm LIMIT ?, ? Yunas 'Abdul' Aziz 2:51am Jul 26 semoga bisa membantu Ermawan 2:54am Jul 26 oh woke mksih mas , tak coba dulu :D Yunas 'Abdul' Aziz 2:55am Jul 26 sip (y)

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions