Hi Abu
To allow the proper operation of your Database Table Editor, when you have tables with multiple indexes, I modified your script in this mode:
row 82:
// set database table for CRUD operations
$g->table = $tab;
// GAGLIARDI
$g->select_command = "WHERE Lingua = '" . $_SESSION["Lingua"] . "'";
// GAGLIARDI
and jqgrid_dist.php in these points:
1. row nr. 690
/* GAGLIARDI
if (!$this->select_command && $this->table)
$this->select_command = "SELECT * FROM ".$this->table;
GAGLIARDI */
if ($this->table && (!$this->select_command || strtolower(substr($this->select_command, 0, 5))=="where"))
$this->select_command = "SELECT * FROM ".$this->table.' '.$this->select_command;
2. row nr. 1538
/* GAGLIARDI
$sql = "UPDATE {$this->table} $update_str WHERE $pk_field IN ($id)";
GAGLIARDI */
if (strpos(strtolower($this->select_command), "where")>-1) {
$where = substr($this->select_command, strpos(strtolower($this->select_command), "where"));
$sql = "UPDATE {$this->table} $update_str $where AND $pk_field IN ($id)";
}
I hope will be helpful.