[TYPO3-calendar] List all events from category in own extension

Christian Leicht usenet at schani.com
Sat Jan 21 13:24:11 CET 2012


Hello cal group,

i like to implement cal events in a own extension. I need to list all 
events from one category and use this SQL Query:

SELECT * FROM tx_cal_event,tx_cal_event_category_mm,tx_cal_category 
WHERE tx_cal_event.uid = tx_cal_event_category_mm.uid_local AND 
tx_cal_event_category_mm.uid_foreign = 6;

Is is possible to extend tis to search the category title field?

Pleas help me with this Query

Christian


More information about the TYPO3-project-calendar mailing list