Good afternoon, i´m working with your example of phpgrid and I Have a problem.
I can work and write to the database with a query only with $ g-> table and $ g-> select_command, but i can´t do the same with a sub query with join and multiple tables
Any ideas?
Thanks for reading my question
Regards
2 Answers
Example: select_command(select ID,fullName as Name from table1 INNER JOIN table 2 as t2 on fullName.Name=t2.ID )
Inner join and Outer Join can be performed within Select_command statement and also u can give customized query over here.
Hello,
As said by varun, it should work in $g->select_command = "YOUR INNER JOIN QUERY";
You can debug using firebug and check actual reason for error.
Your Answer