Kamis, 29 Agustus 2013

PHP Indonesia - Facebook: mastah mau tanya saya Punya tabel seperti ini ida...

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/ 
Shop Best Buy

Find this week's deals in computers, cameras, phones, and more! Choose store pick up or other shipment options.
From our sponsors
mastah mau tanya saya Punya tabel seperti ini ida...
Aug 30th 2013, 02:16, by Danura Aditya

Danura Aditya 2:16am Aug 30
mastah mau tanya saya Punya tabel seperti ini
idanggota | Bulan | Tahun | tabungan
A001 | 02 | 2013 | 100
A001 | 03 | 2013 | 130
A002 | 03 | 2013 | 100
A002 | 04 | 2013 | 10

Bagaimana caranya Jika saya Mau Mengambil Record Bulan dan Tahun Terakhir Terakhir dari A001

Moch Zawaruddin Abdullah 2:22am Aug 30
bisa
select * from tabel where idanggota = 'A001' order by bulan desc, tahun desc limit 0, 1

atau select max ...

Danura Aditya 2:23am Aug 30
oh select Max tahunnya dulu baru Bulannya Yah Mas ???

Danura Aditya 2:33am Aug 30
Oke mas maaf nih kalo itu kan di tabel saya masukin Ke tabel dalam 1 record mas jadi format datanya Long text bagaimana yah saya melakukan operasi CRUD sejauh ini saya cuma Bisa Menyimpan mas

Danura Aditya 2:35am Aug 30
saya save pake ini mas = CONCAT_WS('|',pa_kiri,'$kiri'),

Moch Zawaruddin Abdullah 2:35am Aug 30
maksudnya data ini
A001 | 02 | 2013 | 100

ada dlm 1 field? wow sekali...

Danura Aditya 2:41am Aug 30
Betul Pak

Danura Aditya 2:46am Aug 30
formatnya Long text, saya cuman Bisa simpen aja belum bisa edit sama hapus

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