Start Building Professional
Web Apps Today

i m using dhtmlxgrid but when i update the row then it will not update the row.

Hello,

i m using the below code please tell me what i do or some other way to update the row


<div id="gridbox" style="width:1165px; height:902px;"></div>
<div id="params" style="width:1165px; height:902px;"></div>

<script>
    mygrid = new dhtmlXGridObject('gridbox');
    mygrid.setImagePath('dhtmlxGrid/codebase/imgs/');
    mygrid.setHeader("Add/Del,ShotID,Shotstatus,TaskID,Taskref,Task-Note,Alloted Mandays,UserID,TaskStatus,StartDate,EndDate,Task Priority,Next-Sub,Last-Sub,Actual Mandays,Supervisor");
    mygrid.setColTypes("link,ch,txt,ed,ed,ed,ed,ed,ed,ed,dhxCalendarA,ed,ed,ed,ed");
    mygrid.setSkin("modern")
    
    mygrid.attachHeader("#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter, ,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter")
    
    mygrid.setColSorting("connector,int,connector")

    mygrid.init();
    mygrid.enableSmartRendering(true);
    mygrid.enableMultiselect(true);
        mygrid.loadXML("connector.php");
    var dp = new dataProcessor("connector.php");
    dp.init(mygrid);
    </scirpt>

and this is my code

$res=mysql_connect("localhost","root","");
    mysql_select_db("kanibrainnew1");
    require_once("../dhtmlxConnector_php/codebase/grid_connector.php");
    $grid = new GridConnector($res);
    $grid->dynamic_loading(100);



function myUpdate($action){

mysql_query("UPDATE shot SET userID='{$action->get_value('name')}' WHERE id='{$action->get_id()}'");
$action->success();
}


$grid->render_sql("select * from shot,shotTaskArtist where shotTaskArtist.projID = shot.projID and shot.projID='om' and shotTaskArtist.shotID = shot.shotID","shotID","shotID,shotStatus,taskID,TaskREF,task_note,mandays,userID,taskStatus,startDate,endDate,priority,naxt_sub,last_sub,actualMandays,supervisorName");



please reply me as soon as possible


thanks

Your code looks correct. If you have problems with Grid and Connectors configuration you can contact sales@dhtmlx.com and request for code customization