[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