Load Form Data from URL or MySql data

[karogel]

Im using this code to load the basic info of client and test load info based on sample ID. The function frm_maker_show works fine but the function loadCIRinfo to load the test info does not work. I've attached the url file get_latestCIRdata.php. Please help

<a href="javascript:void(0)" class="easyui-linkbutton" onclick="loadCIRinfo()" style="width:160px">Load Latest CIR info</a>

<script type="text/javascript">
      function frm_maker_show(){
         var row = $('#dgrid_loanapp').datagrid('getSelected');
         if (row){
            urldata = 'modules/application/get_maker_data.php?id='+row.loanAppID;
            $('#dlg_investigate_maker').dialog('open').dialog('setTitle','Credit Investigation - Maker');
            $('#fm_investigate_maker').form('load',row);
            url = 'modules/application/update_investigate_maker.php?id='+row.loanAppID;
         }
      }
      
      function loadCIRinfo(){
                     var newLoanID = 944;
           urldata = 'modules/application/get_latestCIRdata.php?id='+newLoanID;
           $('#fm_investigate_maker').form('load',urldata);
      }


//=== get_latestCIRdata.php ======

<?php
   include '../data/conn.php';
   $id = intval($_REQUEST['id']);
   
   $rs = mysql_query("select *, DATE_FORMAT(appdate,'%d/%m/%Y') from tblloanapp app left join tblmasterdata master on app.makermasterDataID=master.masterdataid
                  where loanAppID=" . $id );
   $rows = array();

   while($r = mysql_fetch_assoc($rs)) {
     $rows[] = $r;
   }

   echo json_encode($rows);   

?>

[stworthy]

The json result returned from 'get_latestCIRdata.php' should be a single object instead of an array objects.

[karogel]

It works. thank you..here's my code:

   include '../data/conn.php';
   $id = intval($_REQUEST['id']);
   
   $rs = mysql_query("select *, DATE_FORMAT(appdate,'%d/%m/%Y') from tblloanapp app left join tblmasterdata master on app.makermasterDataID=master.masterdataid
                  where loanAppID=" . $id );

   $result = mysql_fetch_array($rs);
   echo json_encode($result);