Minggu, 13 Oktober 2013

PHP Indonesia - Facebook: agan" mau tanya ni saya buat lporan mgguan dgan so...

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
agan" mau tanya ni saya buat lporan mgguan dgan so...
Oct 14th 2013, 05:49, by Kanjeng Cint DjyDiningrat LuphOrinda

Kanjeng Cint DjyDiningrat LuphOrinda 5:49am Oct 14
agan" mau tanya ni saya buat lporan mgguan dgan source code sprti ini dan sdh brhasil di sql nya tpi di php y ko mseh eror ya mhon pncrhan thanks
SELECT
a.jenis_barang,
a.jml_bongkar,
b.jml_kemas,
IF(c.jml_muat IS NULL,'',c.jml_muat) AS jumlah_muat
FROM
(SELECT jenis_barang,SUM(jumlah_bongkar) AS jml_bongkar FROM bongkar WHERE tgl_bongkar BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) a
LEFT JOIN
(SELECT jenis_barang,SUM(jumlah_kemas) AS jml_kemas FROM kemas WHERE tgl_kemas BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) b USING(jenis_barang)
LEFT JOIN
(SELECT jenis_barang,SUM(jumlah_muat) AS jml_muat FROM muat WHERE tgl_muat BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) c USING(jenis_barang);

Hairul Anwar 6:00am Oct 14
ini coding ngeri bgt

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