DataTables and LEFT JOINS
DataTables and LEFT JOINS
midjam
Posts: 13Questions: 0Answers: 0
I`m really struggling to get JOINS to work without errors, I posted a question on stackoverflow here: http://stackoverflow.com/questions/8255927/need-help-understanding-mysql-left-joins-and-datatables
And someone was good enough to share a class they had created however, it only works with a PDO connection and my setup is with mysql. I have had a scan through these forums and tried a few methods but, none have worked. Has anyone successfully used JOINs? ie fitting something like the following into DataTables code:
[code]SELECT leads.lead_id, leads.date_time, clients.username, courses.course_type, courses.location_name, CONCAT(first_name,' ',surname)
FROM courses
LEFT JOIN leads ON leads.lead_get_course_id = courses.course_id LEFT JOIN clients ON clients.client_id = courses.course_get_client_id
WHERE leads.checked_by_admin = 'No'[/code]
Really love the look and mechanics of DataTables have everything else setup just how I want it. would hate to go look for alternatives!
And someone was good enough to share a class they had created however, it only works with a PDO connection and my setup is with mysql. I have had a scan through these forums and tried a few methods but, none have worked. Has anyone successfully used JOINs? ie fitting something like the following into DataTables code:
[code]SELECT leads.lead_id, leads.date_time, clients.username, courses.course_type, courses.location_name, CONCAT(first_name,' ',surname)
FROM courses
LEFT JOIN leads ON leads.lead_get_course_id = courses.course_id LEFT JOIN clients ON clients.client_id = courses.course_get_client_id
WHERE leads.checked_by_admin = 'No'[/code]
Really love the look and mechanics of DataTables have everything else setup just how I want it. would hate to go look for alternatives!
This discussion has been closed.