Selasa, 08 Oktober 2013

PHP Indonesia - Facebook: masbro2 & sisbro ...tanya dunk gimana caranya biki...

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/ 
Want free Kindle ebooks?

Sign up to receive the best freebie Kindle ebook deals in your email every day.
From our sponsors
masbro2 & sisbro ...tanya dunk gimana caranya biki...
Oct 8th 2013, 08:04, by Ovix Dodon

Ovix Dodon 8:04am Oct 8
masbro2 & sisbro ...tanya dunk gimana caranya bikin query untuk menampilkan isi database jadi seperti ini :

Cahya Dsn 8:15am Oct 8
email antara baris satu dan dua beda loh.. mo digrouping berdasarkan nama?

mungkin blm sesuai dengan yg diharapkan, tapi bisa dicoba model2:

SELECT nama, GROUP_CONCAT(link) AS link
FROM A
GROUP BY nama

cmiiw ^_^V

Ovix Dodon 8:16am Oct 8
sorry salah ...diumpamakan emailnya sama semua :D

Ovix Dodon 8:17am Oct 8
digrouping berdasarkan emailnya Oom

Cahya Dsn 8:24am Oct 8
ya kurang lebih tinggal dibuat semacam:

SELECT nama,email, GROUP_CONCAT(link) AS link
FROM A
GROUP BY nama,email

.. tergantung kebutuhan berikutnya utk apa, kalo semisal dibuat:

SELECT nama, email,
IF(link='kaskus',link,'') AS source1,
IF(link='google',link,'') AS source2,
IF(link='detik',link,'') AS source3
FROM A
GROUP BY nama,email

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

Tidak ada komentar:

Posting Komentar