Hi,
I have a problem with updating two tables content.
I am using the dhtmlx Standard Edition v.3.6 and Standard Edition v.1.5 PHP Connector,
and I do not know why can’t update tables.
Code:
$grid = new GridConnector($res);
$grid->dynamic_loading(100);
if($grid->is_select_mode())
$grid->render_sql(“select * from program_b left outer join program_a on program_b.pg_a_id = program_a.pg_a_id”, “program_b.pg_b_id”,“pg_a_id,pg_a_name,pg_b_id,pg_b_name,pg_b_exec”);
else {
$grid->event->attach(“afterUpdate”, “doBeforeUpdate”);
$grid->render_table(“program_b”,“pg_b_id”,“pg_b_name,pg_b_exec”);
}
function doBeforeUpdate($action){
mysql_query(“UPDATE program_b SET pg_b_name=‘{$action->get_value(‘pg_b_name’)}’, pg_b_exec=‘{$action->get_value(‘pg_b_exec’)}’ WHERE pg_b_id=‘{$action->get_id()}’”);
$action->success();
}