PHP Indonesia - Facebook: [nubi share oot] calculate IPK, mysql ways.. disa...

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/

Marketing Mobile Apps This online course focuses on marketing efforts that will increase your app's exposure and establish a mobile app marketing plan. Enroll today for $99. From our sponsors

[nubi share oot] calculate IPK, mysql ways.. disa... Sep 7th 2013, 05:32, by Cahya Dsn Cahya Dsn 5:32am Sep 7 [nubi share oot] calculate IPK, mysql ways.. disajikan data (pada tabel t_nilai) sebagai berikut: id|nim|kode_mk|jml_sks|nilai_angka|semester 1|001|AB1|2|4|1 2|001|AB2|3|3|1 3|001|AB3|2|2|2 4|001|AB4|3|3|2 5|002|AB1|2|4|1 6|002|AB2|3|3|1 7|002|AB3|2|3|2 8|002|AB4|3|4|2 untuk menghitung ipk semester 1 dan 2 bisa memakai query: //.. SELECT nim, SUM(IF(semester=1,jml_sks*angka_nilai,0))/SUM(IF(semester=1,jml_sks,0)) AS ipk1, SUM(IF(semester<=2,jml_sks*angka_nilai,0))/SUM(IF(semester<=2,jml_sks,0)) AS ipk2 FROM t_nilai GROUP BY nim atau bisa dilihat contohnya di http://minerva.16mb.com/id=64 jangan dibata, ane cuman sekedar iseng..cmiiw ^_^V Selvieye Slalu Tersenyum 5:34am Sep 7 toeng.... dah tau nanya?? Ulumuddin Cahyadi Yunus 5:38am Sep 7 ^ share, bukan nanya Deni Setiawan 5:46am Sep 7 jadi tabel nilai dipisah sma tabel rencana studi yha om..?? trus jumlah sks n semseter juga disimpan di tabel nilai << bru kepikiran klo ada perubahan sks di makul ga akan ngerubah IPK.. trus kalo itu semester mksud nya 1 untuk ganjil 2 untuk genap atau 1 = smster 1, 2 = smster 2, 3 = smster 3 dst om..?

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