Start Building Professional
Web Apps Today

Hi again, very glad with your support

i have this situation:

I have integrated dhtmlxGrid and dhtmlxCombo with autocomplete. The autocomplete comes from the next file, complete.php:

function getDataFromDB($mask){
  $sql = "SELECT distinct item_nm FROM Countries Where item_nm like '".mysql_real_escape_string($mask)."%'";
  $sql.= " Order By item_nm LIMIT ". $_GET["pos"].",20";

  if ( $_GET["pos"]==0)
   print("<complete>");
  else
   print("<complete add='true'>");
  $res = mysql_query ($sql);
  if($res){
   while($row=mysql_fetch_array($res)){
    print("<option id=\"".$row["item_id"]."\">");
    print($row["item_nm"]);
    print("</option>");
   }
  }else{
   echo mysql_errno().": ".mysql_error()." at ".__LINE__." line in ".__FILE__." file<br>";
  }
  print("</complete>");
 }

well, and the ordinary en the html file:

mygrid.setColTypes("ed,ed,co,dhxCalendar,price,ed,ed[=c4*c5],combo");

So, in this case i have the last column with the dhtmlxcombo with autocomplete....im using an example of the table countries, there are 3 fields: item_id,item_nm,item_cd

It works fine, no errors.

But what happens if i want to save only the id of the selected countrie...

mmmm, i mean:

i write: 'Aust'..... and fast come the Autocomplete with the suggestion: 'Austria'

well, when im done and press Enter, its suppose is inline editing, but there is a method to get the id of the selected option

because i see in the complete.php that generates an xml with:

print("<option id=\"".$row["item_id"]."\">");
    print($row["item_nm"]);
    print("</option>");

so i see $row["item_id"] putting into an 'id' of the option

oohh its so confuse, i hope you understandme, i dont speak english so good

Hello, 

Please, use value instead of id:

...
print("<option value=\"".$row["item_id"]."\">");
...

The value of the selected option is the cell value of the grid. So, you can use the following method:

var value = grid.cells(row_id,cell_index).getValue();