[TYPO3-dev] Problem with pi_list_browseresults()

Brian Bendtsen nightowl at galnet.dk
Thu May 3 09:33:16 CEST 2007


Hi

Im building an extension where I use the pi_list_makelist($res) and 
pi_list_browseresults();

I have an sql that returns 2 records but the browseresults "thinks" that 
there are 4.

I think its because I use group by.

This is my sql:

SELECT * FROM tx_ebbolig_afdeling INNER JOIN tx_ebbolig_lejemaal ON 
tx_ebbolig_afdeling.uid = tx_ebbolig_lejemaal.afdelingid WHERE 
tx_ebbolig_afdeling.organisation = 1 GROUP BY tx_ebbolig_afdeling.uid;

Im not sure what else to post here.

Any idea how to solve this?

/Brian Bendtsen




More information about the TYPO3-dev mailing list