[TYPO3-dev] Problem with pi_list_browseresults()

Brian Bendtsen nightowl at galnet.dk
Mon May 7 10:23:59 CEST 2007


Peter Russ skrev:
> 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.
> 
Hi

Im using mysqlfront and I get 2 results/rows and if I insert count(*) I 
get 2 results/rows with 3 in the first row and 1 in the next.

/BB




More information about the TYPO3-dev mailing list