Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted on Dec 11, 2009 03:31
open dhtmlx forum
on check event update the query

Hello,

i have one checkbox i want to fired oncheck event and update the filed of query from database how it is possible if any wexample please reply as soon as possible.

grid.attachEvent("onCheck", function(rId,cInd,state){

grid.loadxml("common/check_update.php?id="+rid);

});



check_update.php


$sql=mysql_query("update shot set check_y="Y" where shotID="'.$_REQUEST['id'].'"")


and also one quwrtion can i pass column value not index 1,2 value of column please reply me as soon as possible
Answer posted by Alex (support) on Dec 11, 2009 07:49

Hello,

try to use

$sql=mysql_query("update shot set check_y='Y' where shotID='".$_REQUEST['id']."'");

instead of

$sql=mysql_query("update shot set check_y="Y" where shotID="'.$_REQUEST['id'].'"")

The column name can be got by getColumnLabel method:

var label = grid.getColumnLabel(columnIndex);