Start Building Professional
Web Apps Today

DHTMLx Scheduler link with DB Table

I have a table below which I would link to link with the schduler but cant get it to work will

May comeone help

CREATE TABLE IF NOT EXISTS `yearplanner` (
`ItemID` mediumint(9) NOT NULL AUTO_INCREMENT,
UniqueID varchar(10) NOT NULL DEFAULT '0',
`Category` int(10) unsigned NOT NULL DEFAULT '0',
`StartDate` datetime NOT NULL,
`EndDate` datetime NOT NULL,
`Title` varchar(200) NOT NULL,
`Description` varchar(50) NOT NULL DEFAULT '',
`Compulsory` tinyint(1) NOT NULL DEFAULT '1',
`TransactionDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`ItemID`,`UniqueID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;


Thanks for the help.

You can use events.php from default package, just change last line as 

$scheduler->render_table("yearplanner","ItemID","StartDate,EndDate,Title");

Two steps
a) include them in connector init line 
           $scheduler->render_table("yearplanner","ItemID","StartDate,EndDate,Title,some");
b) include them in client side form config
scheduler.config.lightbox.sections=[ 
     {name:"description", height:130, map_to:"text", type:"textarea" , focus:true},
     {name:"custom_name", height:43, type:"textarea", map_to:"some" },
     {name:"time", height:72, type:"time", map_to:"auto"}
]

the document , attached to the next post, contains some advanced details
            http://dhtmlx.com/docs/products/kb/index.shtml?cat=search&page=1&q=10260&ssr=yes&s=scheduler%20form

On server side, you can use render_sql instead of render_table

$scheduler->render_sql("select * from yearplanner where Category = 1","ItemID","StartDate,EndDate,Title");