I use this code to display all the tooling a contact has based on the parentID. The code selects the correct data and displays but will not insert or updates using the same code.
The log displays that C_ID is null. Even though the parentID is sent is 4.
Do you have to write separate update and inserts when you pass parameters ?
I am using a Version 3.5 Pro
<?php
require_once("../codebase/connector/grid_connector.php");// includes the appropriate connector
require_once("../codebase/connector/options_connector.php");// includes the appropriate connector
$dbcon = mysql_connect("localhost","usrnam","passwd");//connects to a server that contains the desired DB
mysql_select_db("dmn_crm");// connects to the DB. 'tasks' is the name of our DB
$grid = new GridConnector($dbcon,"MySQL");// connector initialization
$grid->enable_log("talloc.log",true);
$options = new OptionsConnector($dbcon);
$options->render_table("TBL_TOOLS","ID","ID (value),TOOL (label)");
$grid->set_options("T_ID",$options);
$sqltext = "SELECT * FROM TBL_TOOL_ALLOCATION WHERE C_ID = ".$_GET['parentID'];
$grid->render_sql($sqltext,"ID","C_ID,T_ID,MAKE,OWNER,MODEL,SERIAL,SENSOR_NO,CAL_CERT_DATE,ARQIVA_CERT,ALLOCATED,NOTES,ACTIONS,CERT");
?>