PHP Indonesia - Facebook: [ASK][MySQL] Misal saya punya 3 _________________...

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/

Manage your social media Best social media tool for image publishing to Facebook and Twitter. Look amazing and delight your followers. Get 40% off when you sign up today. From our sponsors

[ASK][MySQL] Misal saya punya 3 _________________... Oct 29th 2013, 06:29, by Rendy de Puniet II Rendy de Puniet II 6:29am Oct 29 [ASK][MySQL] Misal saya punya 3 ____________________ Anggota ---------------------------- IDAnggota|NamaAnggota|IDKota ____________________ Transaksi ---------------------------- IDTransaksi|IDAnggota ____________________ Kota ---------------------------- IDKota|NamaKota Bagaimana cara menampilkan list kota dan kemudian diikuti jumlah transaksinya??? Gunawan Mujur Wibisono 6:35am Oct 29 jumlah pake sum.. jadi select namakota, sum(idTransaksi) from ..... where ..... group by idKota .... silakan di isi... semampunya.. kl menyerah silakan angkat tangan dan akan dibantu kembali.. tp yg pasti sy berharap ... no 1 bs ke jawab Rendy de Puniet II 6:38am Oct 29 trus yg tbl anggota mas??? Cahya Dsn 7:00am Oct 29 SELECT c.namakota,SUM(idtransaksi) AS jml_transaksi FROM transaksi a JOIN anggota b USING(idanggota) JOIN kota c USING(idkota) GROUP BY c.idkota cmiiw ^_^V

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