help with php grid and my own database

Questionshelp with php grid and my own database
RIcardo asked 11 years ago

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
varun answered 11 years ago

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.

Abu Ghufran answered 11 years ago

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.

https://phpgrid.desk.com/customer/portal/articles/926266

Your Answer

0 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?