- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Multiple select dalam satu query (help me!)
TS
Benny-K
Multiple select dalam satu query (help me!)
Ane dapet tugas ni gan, kalo pake excel kelihatan simple banget nih screen shotnya :
ane punya database namanya member isinya kayak gini :
itu cuma contoh doang ya gan
ane coba bikin query biar tampak seperti diexcelnya :
SELECT id_member AS ID, nama_member AS 'Nama Member', id_upline AS 'ID Upline' FROM member UNION SELECT nama_member as 'Nama Upline' FROM member WHERE id_upline = id_member ;
hasilnya query error, emang sih bisa dibikin query 2 kali, tapi ane pengen yang beda, tolong para master web bantu cari jalan keluarnya
ane punya database namanya member isinya kayak gini :
itu cuma contoh doang ya gan
ane coba bikin query biar tampak seperti diexcelnya :
SELECT id_member AS ID, nama_member AS 'Nama Member', id_upline AS 'ID Upline' FROM member UNION SELECT nama_member as 'Nama Upline' FROM member WHERE id_upline = id_member ;
hasilnya query error, emang sih bisa dibikin query 2 kali, tapi ane pengen yang beda, tolong para master web bantu cari jalan keluarnya
Quote:
Original Posted By Benny-K►Setelah berjuang sendirian dibantu mbah Google dan oprek2 seharian sampe lupa kerjaan, akhirnya ketemu juga rumusnya
SET @idupline = (SELECT id_upline FROM xtes WHERE id_member = 4); SELECT 4 AS ID, (SELECT nama_member FROM xtes WHERE id_member = 4) AS 'Nama Member', @idupline AS 'ID Upline', (SELECT nama_member FROM xtes WHERE id_member = @idupline LIMIT 1) AS 'Nama Upline';
hasil dalam screen shoot
Sayangnya cuma bisa 1 baris doang
kalo lebih dari itu muncul error
Tinggal sesuai-in sama php-nya
SET @idupline = (SELECT id_upline FROM xtes WHERE id_member = 4); SELECT 4 AS ID, (SELECT nama_member FROM xtes WHERE id_member = 4) AS 'Nama Member', @idupline AS 'ID Upline', (SELECT nama_member FROM xtes WHERE id_member = @idupline LIMIT 1) AS 'Nama Upline';
hasil dalam screen shoot
Sayangnya cuma bisa 1 baris doang
kalo lebih dari itu muncul error
Tinggal sesuai-in sama php-nya
Diubah oleh Benny-K 08-04-2014 11:17
0
971
4
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan