[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