[TYPO3-dev] include list view from another table in single view

Dmitry Dulepov dmitry at typo3.org
Thu Sep 2 14:35:08 CEST 2010


Hi!

edzjins wrote:
>  Sorry for the mail a few minutes before, something went wrong. Here
>  it goes again, hope correctly this time.

Don't send from the Inbox'es web interface, that's all ;)

>     I've designed a catalog-type extension. It contains of
>  catalog
>    categories, which contain catalog companies, which contain
>  company
>    offers and company details. The thing is, when viewing the
>  single
>    view  of a company, i see information about this company.
>  The thing I
>    need in  addition to this, is to show the offers of this
>  company. The
>    companies  are stored in DB table "tx_erkatalogs_firms",
>  the offers
>    are stored in  DB table "tx_erkatalogs_offers". Offers
>  table have a
>    field which is a  database relation to the company.
>     Please point me what to do to output all the offers of a
>  company in
>    company single view.

It depends on how they are stored. Normally there are just comma-separated
numbers that you can use to fetch records from associated tables. Have a
look into that field in mysql table.

-- 
Dmitry Dulepov
TYPO3 core&security team member
Twitter: http://twitter.com/dmitryd
Read more @ http://dmitry-dulepov.com/




More information about the TYPO3-dev mailing list