I am creating a CRUD application using PHP and the CodeIgniter MVC and it all works very well if I only need to update the columns in the jqGrid table. However I have some tables that have 100-200 columns, so I don't really want to be sending all those in a json string, even if I could handle the table definition.

In this situation I would like to retrieve and list some key attributes from the SQL table in the jqGrid table and then use something like GridParam(“selrow”) on a dblClick to select the row needed and then redirect to another PHP script or function where the full SQL data row could be retrieved, and a new form displayed for editing.

Is this possible?

BTW, top job Tony, you're a legend.