PHP Indonesia - Facebook: [ask|php] misi gan mau nanya ak bru buat file pe...

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 Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

Compare Hotels Find great prices for amazing hotels wherever your next destination may be. It's simple to search 100+ sites at once! From our sponsors

[ask|php] misi gan mau nanya ak bru buat file pe... Nov 13th 2013, 11:11, by Fitrie Utrie Fitrie Utrie 11:11am Nov 13 [ask|php] misi gan mau nanya ak bru buat file pegawai ini habis baru buat form untuk rinciannya, per NIP rinciannya mencakup data pegawai, gaji, tunjangan nah untuk script sqlnya kayak gini <? $h=mysql_query(" select * from pegawai,gaji,tunjangan where pegawai.divisi=gaji.divisi order by pegawai.nip "); $r=mysql_fetch_array($h); ?> tapi kok yang muncul malah entry pegawai yang terakhir yang ak tanyakan, script sql untuk menampilkan data pegawai, gaji, tunjangan sesuai dengan nip gimana ? terimakasih untuk jawabannya :) ZAchary Initial Z 11:15am Nov 13 pake join ZAchary Initial Z 11:15am Nov 13 pake join Thoha Ashidqidulrahman Alfarizhi 11:22am Nov 13 Join... Eof boef ;) Fitrie Utrie 11:27am Nov 13 kayak gini gak jadi Fitrie Utrie 11:27am Nov 13 <? $h=mysql_query("SELECT pegawai.nip, pegawai.nama, pegawai.tgl_lahir,pegawai.jen_kel, pegawai.status, pegawai.gol, pegawai.divisi, pegawai.foto, gaji.divisi, gaji.gaji_pokok, tunjangan.anak, tunjangan.suami_istri, tunjangan.transport FROM(pegawai LEFT JOIN gaji ON pegawai.divisi = gaji.divisi)LEFT JOIN tunjangan ON pegawai.nip = tunjangan.nip "); $r=mysql_fetch_array($h); ?> Fitrie Utrie 11:29am Nov 13 Thoha Ashidqidulrahman Alfarizhi ZAchary Initial Z bisa kasih contoh ??? Thoha Ashidqidulrahman Alfarizhi 11:35am Nov 13 Haaiiiyyaaah ... Situ ikut logikanya aja gimana pasti ketaun alurnya mau kemana ... Sma bikin module buat joint table.a ... Seinget.a si begitu ... Fitrie Utrie 11:38am Nov 13 logika si sedikit jalan tapi buat rumusnya itu yang belum mudeng masih amatir Rismawati Lasa 11:42am Nov 13 <? $h=mysql_query(" select * from pegawai,gaji,tunjangan where pegawai.divisi=gaji.divisi and pegawai.nip = tunjangan.nip order by pegawai.nip "); $r=mysql_fetch_array($h); ?> coba aja dulu cos masih belajar juga.. :) Fitrie Utrie 11:46am Nov 13 done "<? $h=mysql_query(" select * from pegawai,gaji,tunjangan where pegawai.divisi=gaji.divisi and pegawai.nip='$nip'"); ?> " ZAchary Initial Z 11:47am Nov 13 boleh minta struktur masing2 tabel g? Fitrie Utrie 11:57am Nov 13 CREATE TABLE `gaji` ( `divisi` varchar(50) NOT NULL, `gaji_pokok` int(55) NOT NULL, PRIMARY KEY (`divisi`) ) ENGINE=MyISAM DEFAULT CREATE TABLE `pegawai` ( `nip` varchar(30) NOT NULL, `nama` varchar(90) NOT NULL, `tgl_lahir` date NOT NULL, `jen_kel` varchar(15) NOT NULL, `status` varchar(15) NOT NULL, `jml_anak` int(3) NOT NULL, `gol` varchar(5) NOT NULL, `divisi` varchar(15) NOT NULL, `foto` blob NOT NULL, PRIMARY KEY (`nip`) ) ENGINE=MyISAM DEFAULT CREATE TABLE `tunjangan` ( `anak` int(50) NOT NULL, `suami_istri` int(50) NOT NULL, `transport` int(50) NOT NULL ) ENGINE=MyISAM DEFAULT

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