PHP Indonesia - Facebook: Gan ...tanya dunk, ane khan bikin query kaya' gini...

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/

Mobile Game Development Course Learn how to create awesome HTML5 games that run on iPhone, iPad, Android and Desktop! Sign up today for this $99 online course. From our sponsors

Gan ...tanya dunk, ane khan bikin query kaya' gini... Aug 30th 2013, 10:16, by Ovix Dodon Ovix Dodon 10:16am Aug 30 Gan ...tanya dunk, ane khan bikin query kaya' gini SELECT barang.nama_barang, barang.jenis_barang, barang.kd_harga, harga.harga FROM barang, harga WHERE id_barang =1111 nah Outputnya jadi TELEVISION ELEKTRONIK 1 100000 TELEVISION ELEKTRONIK 1 34566 TELEVISION ELEKTRONIK 1 34566 TELEVISION ELEKTRONIK 1 34566 padahal data di tabel harga, cuma 1 row, tapi koq outputnya bisa lebih dari satu yah ...ada yg bisa bantu ? ...Thx before Muhammad Iksan 10:35am Aug 30 hubungannya one to many tuh antara barang sama harga Muhammad Iksan 10:35am Aug 30 kok harga di jadiin table ya? Ovix Dodon 10:37am Aug 30 msh belajar normalisasi gan :D ...btw gimana caranya merubah relasi jadi M to 1 yah ...? Muhammad Iksan 10:38am Aug 30 table harga sih menurut ane ga usah ada, taruh aja jadi satu di table barang, hhe Ovix Dodon 10:39am Aug 30 Ooo ...mending yg dipisah dari barang ntu, kode barang yah ...logikanya khan ada berbagai macam televisi dengan kode yg berbeda .. Muhammad Iksan 10:40am Aug 30 yang di pisah tuh tipe barangnya aja, kalo kaya harga kan satu kesatuan sama barang, ga mungkin barang sama harga beda, hhe Ovix Dodon 10:41am Aug 30 iya yah ...siip deh, btw ntu errornya karna apa yah ? Muhammad Iksan 10:43am Aug 30 itu ga error, cuma dia kan ambil semua data aja, kalo di barang ada 1 row tapi di harga ada 4 row ya dia ambil semua :D Gembel Berkelas 10:43am Aug 30 Group by

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