[Typo3-dev] creating a SELECT DISTINCT with exec_SELECTquery possible?
dan frost
dan at danfrost.co.uk
Thu Oct 21 13:48:02 CEST 2004
Prepend the select clause with DISINCT - because it's kind of part of
that anyway..
E.g. $GLOBALS['TYPO3_DB']->...('DISTINCT header', 'tt_content', ' 1 ');
I think this works
dan
Sacha Vorbeck wrote:
> Hi,
>
> I use ['TYPO3_DB']->exec_SELECTquery to build a select query in my
> extension. But now I need a SELECT DISTINCT. I could solve it with
> ->query or ->SELECTquery but wouldn`t it be better if exec_SELECTquery
> could have another parameter for distinct? Or should a new function
> exec_SELECTDISTINCTquery be added?
>
> Any thoughts on this?
>
More information about the TYPO3-dev
mailing list