[Typo3] TYPO3_DB

[Ries van Twisk]

Pierre wrote:

> hi,
>
> This is the first time i use the DBAL of typo3, and i surely 
> misunderstood something i have this code :
> $select ='DISTINCT(code_direct),rs1,pays';
>                 $from = '2004_AlphaDirects';
>                 $where = 'rs1 REGEXP "^'.$critere.'" ORDER BY rs1';
>                 $res = 
> $GLOBALS['TYPO3_DB']->exec_SELECTquery($select,$from,$where);
> But $res is empty ... the query is OK i've tested it out of typo3.
> Where am i wrong please ?
> Thanks
> Pierre
> _______________________________________________
> Typo3-english mailing list
> Typo3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Piere,

can see see if the exact query is executed in your database log like you 
wanted to be?

cheer,
Ries

-- 
R. van Twisk
http://www.metamorf.net

Our Typo3 enabled website: http://www.livetravelguides.com
Instand help for Typo3?    irc:/irc.freenode.net/typo3
Looking for documentation? http://typo3.org/documentation/