[TYPO3-dev] exec_SELECT_mm_query

[Mario Matzulla]

Rupert Germann schrieb:
> Mario Matzulla wrote:
>> I was working with tt_news and tt_news_cat. Both are related through a
>> M:M relation.
>>
>> Now my problem:
>> If I do an exec_SELECT_mm_query both tables get merged into one
>> result-row. But both tables contain a title column. The tt_news title
>> column gets overwritten by the tt_news_cal column.
>>
>> Shouldn't the result include the table names like "tt_news.title" and
>> "tt_news_cat.title" so this wouldn't happen?
>>
>> Maybe I havn't seen a configuration option, then please point me to it.
> 
> the $select var in this function expects fieldnames to be prepended with the
> tablename. Of course you could also use "AS", f.e.: ... tt_news_cat.title
> AS cattitle, tt_news.title AS newstitle....
> 
> this has to be done manually in your php script.
> 
> greets
> rupert
Thanks Rupert!

Sometimes the solution is closer as one migth think ;)

Cheers,
Mario