jQuery Grid Plugin - jqGrid

OK, i can do with php some trick to load this parameters, but is not an ajax action who loads dynamic information.

<? echo $somevariable; ?>,

and $somevariable= colModel :[name:........., editoptions:{value:"1:Cat1;2:Cat2;....."}]

greatings

Francisco

francisco.penaranda said:

I have a catalog table “Vivientes” but in when I tried to add a field the editoption is not filling the catalog data, because i dont find some addoption or maybe I'm doing something wrong. To understand better here is part of my code:

….

 colModel :[
      {name:'idusuario', index:'idusuario', width:55,editable:false},
      {name:'nombres', index:'nombres', width:90,editable:true},
      {name:'fonos', index:'fonos', width:80, editable:true},
      {name:'idvivientes', index:'idvivientes', width:80, editable:true, edittype:'select',editoptions:{dataUrl: 'ajax/commonactions.php?action=jqgridCombobox&idtable=idviviente&camposhow=nombres&table=Vivientes'}},
      {name:'idgarage', index:'idgarage', width:80, align:'right', editable:true},
      {name:'arrendado_a', index:'arrendado_a', width:90, editable:true},
      {name:'negocio', index:'negocio', width:80, align:'right', editable:true},
      {name:'depto_no', index:'depto_no', width:80, align:'right', editable:true},
      {name:'piso_no', index:'piso_no', width:90, editable:true},
      {name:'mail', index:'mail', width:80, align:'right', editable:true},
      {name:'bloque', index:'bloque', width:80, align:'right', editable:true},
      {name:'no_mascotas', index:'no_mascotas', width:150, sortable:false, editable:true}
    ],

….

and here is my php file

include_once(”../settings/dbconnection.php”);
$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die(”Connection Error: ” . mysql_error());
    mysql_select_db($database) or die(”Error conecting to db.”);
extract($_REQUEST);
if ($action==”jqgridCombobox”){
    $sql=”select $idtable, $camposhow from $table order by $idtable”;
    $result1 = MYSQL_QUERY($sql);
    $numberOfRows1 = @MYSQL_NUM_ROWS($result1);
    for ($j=0;$j<$numberOfRows1;$j++){
        $resultado[$j] = MYSQL_RESULT($result1,$j,$camposhow);
        $idvar[$j] = @MYSQL_RESULT($result1,$j,$idtable);
        if ($j==$numberOfRows1-1){$retorno.=”$idvar[$j]:$resultado[$j]“;}else{$retorno.=”$idvar[$j]:$resultado[$j];”;}
    };
    echo $retorno;
}