I am a student. I use phpgrid at my Project. I set the ID field to selectbox. But as I show namefield value from another table … I want to show with TCPDF showing the namefield. However, the ID field is displayed.
My Database Tables is lesson and selectedcourses . I am sending tables and my php file in the appendix.
These tables are connected to each other via the ID field.
http://www.hamitaksoy.com/problem.zip //Files is here.
Thank you for your help.
1) Set dbname and remove formatter
$col["dbname"] = "invheader.client_id";
2) Set label as id_field (c.name as client_id)
$g->select_command = "SELECT i.id, invdate, c.name as client_id FROM invheader i
INNER JOIN clients c ON c.client_id = i.client_id";
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?