Hello,
please i have probleme to join table to select in create event
my code :
scheduler.load("matieres.php");
var sections11 = scheduler.serverList("sections1");
scheduler.locale.labels.section_des="Type1";
scheduler.config.lightbox.sections = [
{name:"description", height:130, map_to:"text", type:"textarea" , focus:true},
{name:"custom", height:23, type:"select", options:sections, map_to:"section_id" },
{name:"des", height:23, type:"select", options:sections11, map_to:"type1" }
];
and in matieres.php :
$dbtype = "MySQL";
$res=mysql_connect("localhost", "root", "");
mysql_select_db("base2");
require_once('codebase/connector/scheduler_connector.php');
$options = new OptionsConnector($res, $dbtype);
$SQL = "SELECT code_mat,nom_mat from matiere";
$options->render_sql($SQL,"code_mat","code_mat(value),nom_mat(label)");
$scheduler = new schedulerConnector($res, $dbtype);
$scheduler->set_options("sections1",$options);
but, he does not load data in select.