on check event update the query

Discontinued products Uncategorized discussions
#1

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

#2


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);