Use where condition in $scheduler->render_table(.........)

Scheduler Javascript
#1

$seq=$_GET[‘id’];

i want to filter the data as per $seq value.
so want to set where condition in below statement…

staff=$seq;

How to include Where condition in the query?

   [code] include ('db/scheduler_connector.php');
include ('db/config.php');
$seq=$_GET['seq'];
$res=mysql_connect($server, $user, $pass);
mysql_query("set names UTF8");
mysql_select_db($db_name);
$list = new OptionsConnector($res);
$list->render_table("TM_Staff","seq","seq(value),name(label)");
$scheduler = new schedulerConnector($res);
$scheduler->set_options("staff", $list);

$scheduler->render_table(“tevents”,“event_id”,“start_date,end_date,event_name,staff,site”);[/code]

$scheduler->render_table(“tevents”,“event_id”,“start_date,end_date,event_name,site,staff”);

thank you…

#2

plz reply me anybody…

#3

Hi Vijai,
Have you reviewed the following document?
docs.dhtmlx.com/doku.php?id=dhtm … ace_object

At the bottom of the page it shows you the syntax to filter on the connector…
Kind regards
Greg

#4

More filtering:
docs.dhtmlx.com/doku.php?id=dhtm … :filtering

#5

Above links shows one of the ways to filter a data.
If you need to use data feed only for loading ( not saving ) , you can use render_sql instead of render_table

$scheduler->render_sql("select * from tevents where staf='$sec'","event_id","start_date,end_date,event_name,site,staff");
#6

thank you so much ggold10 and Stanislav…
its working good.