DHTMLXConnector update with 2 key

Discontinued products Uncategorized discussions
#1

Hi,

This is my connector:



<?php

    require_once("…/…/Suite25/dhtmlxConnector/php/codebase/grid_connector.php");



    $res=mysql_connect(“localhost”,“root”,“sandbgroup”);

    mysql_select_db(“hr_mysql”);



    $grid = new GridConnector($res);

    $grid->set_encoding(“ISO-8859-1”);

    $grid->dynamic_loading(100);

    $grid->render_table(“hs_hr_attendance”,“attendance_id”,“employee_id,punchin_time,in_note,punchout_time,out_note,status”);

?>



It works great but my question is:

How can i do if i must update records in a table that has 2 keys…?



ex: employee_id and day_of_week are that keys:

the sql statement should be:

UPDATE hs_hr_hours SET data WHERE employee_id=x AND day_of_week=y.



which is the right syntax?



$grid->render_table(“hs_hr_hours”,“employee_id,day_of_week”,“punchin_time,in_note,punchout_time,out_note,status”);





Thank u