port:".$port; echo "

strcd:".$strcd; echo "

frdt:".$frdt; echo "

vencd:".$vencd; echo "

pn:".$pn; */ include "./../comon/dbconn.inc"; $qr = "SELECT VEN_CODE, ". "CONVERT(VARBINARY(200), VEN_NAME) VEN_NAME, ". "MCH_TYP, ISNULL(MFEE_RATE, 0) MFEE_RATE, STOPVENDOR FROM MMSVEM WHERE STR_CODE = '$strcd' ORDER BY VEN_CODE"; $ret = mssql_query($qr, $dbconn); if (! $ret) { echo ('{"RET":"QRY", "ERMSG":"°Å·¡Ã³ Á¶È¸ ¿À·ùÀÔ´Ï´Ù."}'); mssql_close(); exit(); } $arr = array(); $arr["RET"] = "OK"; $venArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["VENCD"] = $row["VEN_CODE"]; $rowArray["VENNM"] = BinToKor($row["VEN_NAME"]); $rowArray["MCH"] = $row["MCH_TYP"]; $rowArray["MFEE"] = $row["MFEE_RATE"]; $rowArray["STOP"] = $row["STOPVENDOR"]; array_push($venArray, $rowArray); } $arr["VENDOR"] = $venArray; $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>