How to work with a JOIN in PHPGRID

Questions › How to work with a JOIN in PHPGRID

Peter asked 11 years ago

I'm trying to use the following command:
SELECT * from OBSERVATIES
JOIN DOCENT ON DOCENT.DOCENTid = OBSERVATIES.DOCENTid

In PHPMYADMIN this works fine but how can I use it in PHPGRID?
or can somebody explain to me how to use a join-command PHPGRID.

1 Answers

Abu Ghufran answered 11 years ago

You juts need to set
$g=new jqgrid();
$g->select_command = "sql";

Your Answer