pekanzz 0 Report post Posted October 11, 2004 salamz,aku ade satu table lebey kurang cam nih laa:sumDate sumCall sumPort sumFail sumCon-------------------------------------------------------30/8/04 1 3 0 130/8/04 1 2 1 030/8/04 1 2 0 1Soalan: Cam ner aku nak kira total sumCall sum Fail sumCon? Cam ner aku nak sumarizekan jadi kpd 1 Date which is 30.8.04 dgn total data?Reason: Aku nak summarizekan sume utk create graph.. the thing is aku sangkut kat query nih which is aku nak generate php. Kira first of all aku nak kena show the summary first sebelum aku proceed to graph.thank you! Quote Share this post Link to post Share on other sites
muhamadnasron 0 Report post Posted October 14, 2004 mmm kalo tak silap aku camni.. guna function sumSELECT sum(sumCall), sum(sumPort), sum(sumFail), sum(sumCon) FROM nama_tbl_ko WHERE sumDate = '30/8/04'kalo ko nak date ko tu dinamik, letak la sbg variable.. ok cantek...?wallahua'lam...*ntah betul ntah tak.... Quote Share this post Link to post Share on other sites
muhamadnasron 0 Report post Posted October 14, 2004 rujukan sql functionw3schools Quote Share this post Link to post Share on other sites
azuan 2 Report post Posted October 26, 2004 tak ada respon dah dari si penanya? lengkali kalau dah tanya, orang dah jawab, bebawak la tutup soalan tu. jangan dok diam diam je. Quote Share this post Link to post Share on other sites
muhamadnasron 0 Report post Posted October 27, 2004 penat je menjawabnye.....takpelah.. kalo bukan utk rujukan dia, utk puteranians sume....tak ilang ilmu diperturun.....wallahua'lam Quote Share this post Link to post Share on other sites
tapaiPulut 0 Report post Posted October 27, 2004 utk tarikh gunakan # cth #12/10/2004#utk String baru guna ' cth nama = 'Putera' Quote Share this post Link to post Share on other sites
Mr.Big 0 Report post Posted November 17, 2004 pekanz tido kot...aku cakap terima kasih bagi pihak dia... Quote Share this post Link to post Share on other sites