Dropdown and autocomplete

<?php
include_once("../conn/db_connect.php");
include_once("../phpgrid/config.php");

// include and create object
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

// Database config file to be passed in phpgrid constructor
$db_conf = array("type" => PHPGRID_DBTYPE, "server" => PHPGRID_DBHOST, "user" => PHPGRID_DBUSER, "password" => PHPGRID_DBPASS, "database" => PHPGRID_DBNAME );

$g = new jqgrid($db_conf);

$opt["caption"] = "PUEBA";
$opt["toolbar"] = "bottom";
$opt["rowNum"] = 12;
$opt["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'780');
$opt["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'780');
$g->set_options($opt);


$g->set_actions(array("add"=>true, "edit"=>true, "bulkedit"=>false, "delete"=>true, "rowactions"=>false, "autofilter" => true, "search" => "simple"));

$g->select_command = "SELECT pr.codPrueba, pr.codPatologia, pa.patologia, pr.codDiagnostico, di.diagnostico
                        FROM prueba pr
                        INNER JOIN gen_patologia pa ON pr.codPatologia=pa.codPatologia
                        INNER JOIN gen_diagnostico di ON pr.codDiagnostico=di.codDiagnostico";

// set table for CRUD operations
$g->table = "prueba";

// Id
$col = array();
$col["title"] = "Id";
$col["name"] = "codPrueba";
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "Patologia";
$col["name"] = "codPatologia";
$col["editable"] = true;
$col["editrules"] = array("required"=>true);
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "Diagnostico";
$col["name"] = "codDiagnostico";
$col["editable"] = true;
$col["hidden"] = true;
$col["editrules"] = array("required"=>true);
$cols[] = $col;

$col = array();
$col["title"] = "Patologia";
$col["name"] = "patologia";
$col["editable"] = true;
$col["width"] = "130";
$col["editoptions"] = array("size"=>70, "maxlength"=>"70", "onchange"=>array("sql"=>"SELECT codDiagnostico AS k, concat(diagnostico,codPatologia) AS v FROM gen_diagnostico WHERE codPatologia='{codPatologia}' ORDER BY diagnostico", "update_field"=>"diagnostico"));
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array("sql"=>"SELECT codPatologia AS k, patologia AS v FROM gen_patologia ORDER BY patologia", "search_on"=>"patologia", "update_field"=>"codPatologia");
$cols[] = $col;

$col = array();
$col["title"] = "Diagnostico";
$col["name"] = "diagnostico";
$col["editable"] = true;
$col["width"] = "150";
$col["editoptions"] = array("size"=>90, "maxlength" => "90");
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array("sql"=>"SELECT codDiagnostico AS k, diagnostico AS v FROM gen_diagnostico ORDER BY diagnostico", "search_on"=>"diagnostico", "update_field"=>"codDiagnostico");
$cols[] = $col;

$g->set_columns($cols);

// render grid
$out = $g->render("list1");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
    <link rel="stylesheet" type="text/css" media="screen" href="../phpgrid/lib/js/themes/<?php echo "cupertino" ?>/jquery-ui.custom.css"></link>
    <link rel="stylesheet" type="text/css" media="screen" href="../phpgrid/lib/js/jqgrid/css/ui.jqgrid.css"></link>

    <script src="../js/utiles.js" type="text/javascript"></script>
    <script src="../phpgrid/lib/js/jquery.min.js" type="text/javascript"></script>
    <script src="../phpgrid/lib/js/jqgrid/js/i18n/grid.locale-es.js" type="text/javascript"></script>
    <script src="../phpgrid/lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="../phpgrid/lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
</head>
<body>
    <div style="margin:10px">
    <?php echo $out?>
    </div>
</body>
</html>

/*
CREATE TABLE `prueba` (
  `codPrueba` int(11) NOT NULL,
  `codPatologia` int(11) NOT NULL,
  `codDiagnostico` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `prueba`
  ADD PRIMARY KEY (`codPrueba`);
ALTER TABLE `prueba`
  MODIFY `codPrueba` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `gen_patologia` (
  `codPatologia` smallint(6) NOT NULL,
  `patologia` varchar(100) NOT NULL,
  `codTipoEstado` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `gen_patologia` (`codPatologia`, `patologia`, `codTipoEstado`) VALUES
(1, 'DISCAPACIDAD', 1),
(2, 'HIV', 1);
ALTER TABLE `gen_patologia`
  ADD PRIMARY KEY (`codPatologia`);

CREATE TABLE `gen_diagnostico` (
  `codDiagnostico` int(11) NOT NULL,
  `codigo` varchar(10) NOT NULL,
  `diagnostico` varchar(100) NOT NULL,
  `codGrupo` tinyint(4) NOT NULL,
  `codPatologia` int(11) NOT NULL,
  `sur` char(1) NOT NULL,
  `surMedicamento` char(1) NOT NULL,
  `resolucion331` char(1) NOT NULL,
  `codTipoEstado` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `gen_diagnostico` (`codDiagnostico`, `codigo`, `diagnostico`, `codGrupo`, `codPatologia`, `sur`, `surMedicamento`, `resolucion331`, `codTipoEstado`) VALUES
(1, 'A000', 'COLERA DEBIDO A VIBRIO CHOLERAE O1, BIOTIPO CHOLERAE', 0, 1, 'N', 'N', 'N', 1),
(2, 'A001', 'COLERA DEBIDO A VIBRIO CHOLERAE O1, BIOTIPO EL TOR', 0, 1, 'N', 'N', 'N', 1),
(3, 'A009', 'COLERA NO ESPECIFICADO', 0, 1, 'N', 'N', 'N', 1),
(4, 'A010', 'FIEBRE TIFOIDEA', 0, 1, 'N', 'N', 'N', 1),
(5, 'A011', 'FIEBRE PARATIFOIDEA A', 0, 1, 'N', 'N', 'N', 1),
(6, 'A012', 'FIEBRE PARATIFOIDEA B', 0, 2, 'N', 'N', 'N', 1),
(7, 'A013', 'FIEBRE PARATIFOIDEA C', 0, 2, 'N', 'N', 'N', 1),
(8, 'A014', 'FIEBRE PARATIFOIDEA, NO ESPECIFICADA', 0, 2, 'N', 'N', 'N', 1),
(9, 'A020', 'ENTERITIS DEBIDA A SALMONELLA', 0, 2, 'N', 'N', 'N', 1),
(10, 'A021', 'SEPTICEMIA DEBIDA A SALMONELLA', 0, 2, 'N', 'N', 'N', 1),
(11, 'A022', 'INFECCIONES LOCALIZADAS DEBIDA A SALMONELLA', 0, 2, 'N', 'N', 'N', 1),
(12, 'A028', 'OTRAS INFECCIONES ESPECIFICADAS COMO DEBIDAS A SALMONELLA', 0, 2, 'N', 'N', 'N', 1);
ALTER TABLE `gen_diagnostico`
  ADD PRIMARY KEY (`codDiagnostico`);
*/