How to pass data to the dhtmlconnect?

Suite and Optimus Suite 5
#1

Hello,

I’m new to dhtmlx… and just trying this great AJAX framework with connection to mysql.
Could you please help me to find a way how to pass data to dhtmlxconnect from a grid?
I have one of my mysql tables reflected in grid and would like based on the selected a record in the grid (id) to perform search in the another mysql table and display result in the other another another grid … ?

Thanks in advance
Igor

#2

Sorry for typo I mean dhtmlConnector vs. dhtmlconnect …

#3

You can have on page

grida.attachEvent(“onRowSelect”, function(id){
gridb.clearAll();
gridb.load(“datab.php?for=”+id);
})

where datab.php is source of data for grid b, and can use your custom code or connector with render_sql

$grid->render_sql(“SELECT * FROM tableB WHERE some=”.$_GET[‘for’]);