<link rel="stylesheet" href="dhtmlxscheduler.css" type="text/css" media="screen" title="no title" charset="utf-8">
<link rel="stylesheet" href="dhtmlxscheduler_recurring.css" type="text/css" title="no title" charset="utf-8">
<?
$query="SELECT name,seq FROM TM_Staff";
$result = mysql_query ($query);
echo "name";
while($nt=mysql_fetch_array($result)){
echo "$nt[name]";
}
echo "";
?>
[/b]
types.php
include ('db/scheduler_connector.php');
include ('db/config.php');
[b]$seq=$_GET['seq'];[/b]
$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,site,staff");
the seq value is referencing the tevents table staff value…
ie, staff=$seq
[b]how to make the query
select * from tevents where staff=$seq[/b]
help me… thanks in advance…