$MembreList = new OptionsConnector($res);
$MembreList->render_sql(“SELECT a.course_id as courseid , b.name as cname FROM coursemaster a , coursemaster_description b where (a.course_id = b.course_id ) and b.langid=’”.$default_lang."’ and a.organizationid = ‘".$_SESSION[‘org_id’]."’ ",“a.course_id(courseid)”,“courseid(value),cname(label)”);
i want to display data from two tables using join query. I tried with above list. But it doesn’t display any value combobox. Combobox filled with blank values.
I also track log.txt file.
It gives me below error.
SELECT a.course_id as courseid , b.name as cname FROM coursemaster a , coursemaster_description b WHERE ( (a.course_id = b.course_id ) and b.langid=‘6’ and a.organizationid = ‘6’ )
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: label at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260
Undefined index: value at D:\wamp\www\mathtoapp\v4\dhtmlx\codebase\base_connector.php line 260