Start Building Professional
Web Apps Today

Complex Select with Connector

Hi,
i'm tring to create a complex select with render_sql method but i'm surelly not doing the right stuff on syntax:

my quesry is:

$timeshhet->render_sql("SELECT * FROM hs_hr_employee b JOIN(hs_hr_emp_locations a JOIN hs_hr_attendance c ON(a.emp_number=c.employee_id) JOIN hs_hr_location l ON(a.loc_code=l.loc_code)) ON(b.emp_number=a.emp_number) WHERE b.employee_id=" ."'". $_GET["filter"] ."'","attendance_id","employee_id,punchin_time,in_note,punchout_time,out_note,status");

in other cases the query works but i have to convert in render_sql syntax..

could u pls help me?

Thank u

What version of dhtmlxGrid do you use? dhtmlxConnector version 0.9 has issue with complex sql query. Please try to use latest version http://dhtmlx.com/docs/products/dhtmlxConnector/index.shtml

I'm using 0.95 php version...