I can insert, update, delete the rows from grid when i am working with single table. But when i go for multiple tables i am facing problem in updateing and deleting the grid data. By using Mysql join, i am loading data, but i cant insert, update or delete rows.
How to solve this problem?
Thanks.
Hi,
Here i'm using "fw_activity_master" one table and "fw_application_master" one more table.using inner join and taken "Applicationname " name..
$g->select_command = "SELECT * FROM (SELECT i.ACM_slno, i.AM_slno, i.CM_slno,i.Activityname, i.Formname,i.Status, i.Startdate, i.Enddate, i.Txnuser, i.Txndate,o.Applicationname FROM fw_activity_master i INNER JOIN fw_application_master o ON o.AM_slno = i.AM_slno) o ";
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!