Re: [TYPO3-english] MySQL query error

2013-09-26 Thread Christian Futterlieb
Hi Thomas Thx. if i run a MYSQL query ind my DB i get the right data, when i then add the query to my TS, like ur code, i see the page, but im not getting any data showed.. Is there something i have missed !? The query built from the typoscript automatically filters by some fields like pid,

Re: [TYPO3-english] MySQL query error

2013-09-26 Thread Christian Futterlieb
Hi Thomas You cannot use php code in typoscript. This is the typoscript equivalent to your code below (not tested): lib.drilllist = CONTENT lib.drilllist { table = Strukturtx_drillings_domain_model_drillcat select { selectFields = categorytitle orderBy = categorytitle A

[TYPO3-english] MySQL query error

2013-09-26 Thread Thomas Petersen
Hi Im new to Typo3. I need to get some date from a DB, and i have added the tables ex. I have then under "link"->"Template" made this TS-script "soccerlist". lib.drilllist = CONTENT lib.drilllist { //Select Query $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db, 'SELECT categorytitle FROM Strukturtx_