jQuery Grid Plugin - jqGrid

<?php

if($action == "buildKVP")
{
    $table = $_REQUEST['table'];
    $keyField = $_REQUEST['keyField'];
    $valueField = $_REQUEST['valueField'];
    $where = $_REQUEST['where'];
    
    if($where != "") $where = " WHERE " . $where;
    
    $SQL = "SELECT ($keyField) AS keyField, ($valueField) AS value FROM $table $where ORDER BY value";
    $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());
    
    $i=0;
    while($row = mysql_fetch_array($result,MYSQL_ASSOC))
    {
        $response->table = $table;
        $response->data[$i]['key']=$row[keyField];
        $response->data[$i]['value']=$row[value];
        $i++;
    }

    echo json_encode($response);
}

?>

var objMyList = buildKVP({table:"myTableName", keyField:"id", valueField:"name"});

colModel:[{name:'myField', ..., formatter:'select', edittype:'select', editoptions:{value: objMyList.string}}]

<script>

function buildKVP(params) // params: {table:"tableName", keyField:"keyName", valueField:"valueName"}
{
    if(typeof params.where === "undefined") params.where = "";
    
    var myVar;
    myVar = jQuery.ajax(
    {
        type: "POST",
        async: false,
        url: "myDataHandler.php",
        data:
        {
            action: "buildKVP",
            table: params.table,
            keyField: params.keyField,
            valueField: params.valueField,
            where: params.where
        },
        success: function(data)
        {
            // Do Something
        }
    });
    var myData = {};
    
    myData.object = eval("(" + myVar.responseText + ")");
    
    var strAssembly = "";
    for(x in myData.object.data)
    {
        if(typeof myData.object.data[x].key !== "undefined")
        {
            if(strAssembly != "" ) strAssembly += ";"
            strAssembly += myData.object.data[x].key + ":" + myData.object.data[x].value;
        }
    }
    
    myData.string = strAssembly;
    
    return myData;
}

</script>

<script>

function loadSubService(parentKey, elmID)
{
    var dsSubService = buildKVP({table:"my_table_name", keyField:"id", valueField:"name/desc_field", where: "parentID = " + parentKey}).object;
   
    var curServiceList = "";
   
    for(key in dsSubService.data)
    {
        // if(curServiceList === "") curServiceList += '<option value=""></option>';
        if(typeof dsSubService.data[key].key !== "undefined")
            curServiceList += '<option value="'+ dsSubService.data[key].key +'">'+ dsSubService.data[key].value +'</option>\n';
    }
   
    jQuery(elmID).empty();
   
    if(curServiceList !== "")
        jQuery(elmID).append(curServiceList);
    else
        jQuery(elmID).append('<option value="0">No Dependant Fields Assigned</option>');
}

</script>