[TYPO3-dev] Problem with pi_list_browseresults()

Peter Russ peter.russ at 4many.net
Thu May 3 23:13:28 CEST 2007


Brian Bendtsen schrieb:
> 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
How many results do you get, running the query with phpmyadmin?

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ




More information about the TYPO3-dev mailing list