Minggu, 08 September 2013

PHP Indonesia - Facebook: cara ngambil data dari tabel pd gambar ini gmana y...

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/ 
Start taking a college level music theory class today.

This beginner class is now accessible to aspiring musicians of all ages. Learn all of the basic concepts in an easy to follow manner.
From our sponsors
cara ngambil data dari tabel pd gambar ini gmana y...
Sep 8th 2013, 16:24, by Laa Nilla

Laa Nilla 4:24pm Sep 8
cara ngambil data dari tabel pd gambar ini gmana ya ,
mau ambil tabel absen yg kelas_id = 1 , nah di tabel absen itu gak ada kelas_id nya tapi ada field peserta_id yg merujuk ke tabel kelas , cara ngejoinnya atau cara mbilnya gmana y dlm 1 query

Andi Malik Rizki Maula 4:31pm Sep 8
cara ngambil datanya select dari tabel absen join tabel peserta on absen.peserta_id = peserta.peserta_id, terus di-join lagi dengan tabel kelas on peserta.kelas_id = kelas.kelas_id where kelas.kelas_id = 1

Indra Chaidir 4:33pm Sep 8
SELECT
absen.absen_id
, peserta.peserta_id
, kelas.kelas_id
FROM
absen
INNER JOIN peserta
ON (absen.peserta_id = peserta.peserta_id)
INNER JOIN kelas
ON (peserta.kelas_id = kelas.kelas_id);

*seandainya ada contoh isi tiap2 table lebih bagus, biar bisa keliatan hasil yg diinginkan..

Kak Azmi 4:39pm Sep 8
baca aja dulu di w3school biar ngerti konsep join

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

Tidak ada komentar:

Posting Komentar