Minggu, 10 November 2013

PHP Indonesia - Facebook: Mhon bantuan utk membuat query mysql, 3 tabel jadi...

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/ 
Creating iOS Games: Beginner Course

Marin Todorov teaches you how to create an iPhone game easily and simply using Cocos2d in this $99 online course.
From our sponsors
Mhon bantuan utk membuat query mysql, 3 tabel jadi...
Nov 10th 2013, 12:39, by Irwan Hardiansyah

Irwan Hardiansyah 12:39pm Nov 10
Mhon bantuan utk membuat query mysql, 3 tabel jadi 1. Agar lebih jelas lihat di ilustrasi gambar.

Yang mau bikinin query mysqlnya, ane kasih pulsa 50rb. serius.
Bikin contoh file + databse-nya.

Yana Setiono 12:43pm Nov 10
Direlasikan dg inner join bruw

Irwan Hardiansyah 12:44pm Nov 10
bs minta arahan scriptnya?

Irwan Hardiansyah 12:46pm Nov 10
soalnya udah baca-bca buku, cari2 di om gogel, msh blm ktm jg.

Irwan Hardiansyah 12:52pm Nov 10
ane kasih pulsa 50rb utk yg mw bkinin query mysql-nya, contoh file php ama databasenya.

Irwan Hardiansyah 12:56pm Nov 10
serius, bth bntuan.

Irwan Hardiansyah 1:01pm Nov 10
pls help

Malang Ngalam 1:04pm Nov 10
udh bs blm bro

Malang Ngalam 1:04pm Nov 10
blh aq bantu bro

Malang Ngalam 1:05pm Nov 10
coba add aq bro aq gak bs add friend nih..

Andri Rosandi 1:08pm Nov 10
kalau ane lebih milih ngebuat 2 tabel aja... table "pesan" dan tabel "jenisPesan"..
"pesan", fields:
1. idPesan
2. noTlp
3. waktu
4. isiPesan
5. idJenis

"jenisPesan", fields:
1. idJenis
2. jenisPesan

query "select pesan.waktu, pesan.noTlp, pesan.isiPesan, jenisPesan.jenisPesan from pesan inner join jenisPesan on pesan.idJenis = jenisPesan.idJenis order by pesan.waktu desc"

Malang Ngalam 1:12pm Nov 10
intinya gini bro query nya : select tabel1.*, tabel2.*, tabel3.* from tabel1 on tabel2 left join tabel2 on tabel3 left join tabel1 on tabel3 (nmrku 089682145551)

Irwan Hardiansyah 1:12pm Nov 10
Malang Ngalam : blm bs, aku jg gk bs add ke agan
Andri Rosandi : database yg ada skg seperti itu, dan itu gk bisa dirubah karena bawaan aplikasinya, kalo dirubah gak bisa update lg nantinya.

Malang Ngalam 1:13pm Nov 10
ada kontak gtalk or ym bro biar enak komunikasi nya ;)

Irwan Hardiansyah 1:14pm Nov 10
ym ke irwanz8910

Malang Ngalam 1:15pm Nov 10
udh aq add bro

Hendra Effendi 1:18pm Nov 10
Select InsertDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'outbox' as Folder FROM outbox union all Select ReceivingDateTime as DateTime,SenderNumber as PhoneNumber,SMS as SMS, 'inbox' as Folder FROM inbox union all Select SendingDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'sentitems' as Folder FROM sentitems order by DateTime desc;

belum sempurna, tp silahkan dicoba ..
semoga membantu ..

Andri Rosandi 1:31pm Nov 10
udah terselesaikan sama Hendra Effendi...

Hendra Effendi 1:33pm Nov 10
tinggal sedikit lagi mas , masih belum bisa buat folder outbox record always on top ..
silahkan disempurnakan lagi ..

Anshar Firman Haryadi 1:34pm Nov 10
Select InsertDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'outbox' as Folder FROM outbox union all Select ReceivingDateTime as DateTime,SenderNumber as PhoneNumber,SMS as SMS, 'inbox' as Folder FROM inbox union all Select SendingDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'sentitems' as Folder FROM sentitems order by DateTime and folder desc;

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