Hello , please tell me how we mapping the two query . below is the my code please tell me how we write the query also i want to pass trhe value of select box to connected.php i m using ajax code but if i am write in my query “$_REQUES[‘projid’]” then it gives me error . is it possible or not please reply me as soon as possible.
<?php $res=mysql_connect(“localhost”,“root”,"");
mysql_select_db(“kanibrainnew1”);
require_once("…/dhtmlxConnector_php/codebase/grid_connector.php");
// $projID=$_REQUEST[‘projid’];
$grid = new GridConnector($res);
$grid->dynamic_loading(100);
//$grid->render_table(“products”,“nm”,“code,num_val,shotid,shotstatus,taskid,taskref,tasknote,userid,taskstatus,start_date,end_date,alloted_mandays,task_priority,next_sub,actual_manday”);
$grid->render_sql(“select * from shot,shotTaskArtist where shotTaskArtist.projID = shot.projID and shot.projID=‘om’ and shotTaskArtist.shotID = shot.shotID”,“shot.shotID”,“shotID,shotStatus,taskID,TaskREF,task_note,mandays,userID,taskStatus,startDate,endDate,priority,naxt_sub,last_sub,actualMandays,supervisorName”);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
“http://www.w3.org/TR/html4/loose.dtd”>
<!-- addd for multiple select dropdown —>
<!-- addd for multiple select dropdown —>
dhtmlxConnector tutorial is available here support@dhtmlx.com and provide you ref. ID.