[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