window.alert("ไม่พบปันผล-เฉลี่ยคืน ในปีที่ท่านเลือก") '; echo ""; exit; } $strSQL1 = "SELECT (SELECT METHPAYTYPE_DESC FROM YRUCFMETHPAY WHERE METHPAYTYPE_CODE=DIV.METHPAYTYPE_CODE) AS DIVPAYTYPE_DESC, TO_CHAR(DECODE(EXPENSE_AMT,0,null,EXPENSE_AMT),'99G999G999G999D00') AS ITEM_AMT , (SELECT BANK_DESC FROM CMUCFBANK WHERE BANK_CODE=DIV.EXPENSE_BANK) AS BANK_DESC, EXPENSE_ACCID AS BANK_ACCID FROM YRDIVMETHPAY DIV WHERE DIV.MEMBER_NO = '$member_no' AND DIV.DIV_YEAR= '$divyear'"; $value1 = array('DIVPAYTYPE_DESC','ITEM_AMT','BANK_DESC','BANK_ACCID'); list($Num_div1,$slip_show1) = get_value_many_oci($strSQL1,$value1); //echo $Num_div1; $typepay = $slip_show1[0][0]; $totalpay = $slip_show1[0][1]; $bank_desc = $slip_show1[0][2]; $bank_acc = $slip_show1[0][3]; ?>