Display grid from multiples tables

You can create a SQL View and use that as a table.

e.g.
CREATE VIEW MY_VIEW AS
SELECT *
FROM Table1 INNER JOIN Table2 ON Table1.fid = Table2.id

$dg = C_Datagrid("select * from my_view", "id", "my_view");

Edit is not possible with SQL View. Hope this helps,


Feedback and Knowledge Base