We need a way to show a value instead of a key when EDIT is required
Given you don't support an INNER JOIN, and apparently, when using a view, one can't use edit, we need a way to show a value instead of a key on grids that you want to use for edits. For instance, when listing an Orders table, you want to show the Customer's name, not their ID.
Yes Enas, I've managed to get that working as well, only then the grid is non-editable... The set_col_edittype works while remaining the functionality to edit.
AdminRichard (Admin, phpGrid) commented
Please use "select" edit type. See http://phpgrid.com/documentation/set_col_edittype/
$sdg = new C_DataGrid("SELECT `t1`.ticket_id AS `ticket_id`, `t2`.quantity,
FROM `Tickets` AS `t1` JOIN `Order` AS `t2` ON `t1`.ticket_id = `t2`.ticket_id", "ticket_id", $sdg_table_name);
This has worked for me so far .