Moin,
folchendes Problem: wie kann ich nach einem Select eine andere Tabelle abfragen und dabei auf ein vorher schon abgefragtes Feld verweisen?
lib.videocast = COA
lib.videocast {
10 = CONTENT
10 {
table = tx_minesite_company
select {
pidInList = 30
max = 1
where = video > ''
}
renderObj =COA
renderObj{
10 = COA
10 {
10=TEXT
10 {
field=videoimg
typolink.parameter = 69
typolink.wrap = <img src="uploads/tx_minesite/{field:feuser}/|" style="width:94px" border="0" align="left" />
typolink.ATagBeforeWrap = 1
typolink.additionalParams.insertData = 1
typolink.additionalParams = &tx_minesite_pi1[cid]={field:uid}
}
20=CONTENT
20 {
table = fe_users
select {
where = uid = {field:feuser}
}
renderObj =COA
renderObj{
10 = COA
10 {
10 = TEXT
10.field = company
10.wrap = <img src="fileadmin/templates/images/title_videofeeds.gif" alt="Video feeds" width="94" height="15" /><br />|<br />
}
}
}
30 = TEXT
30 {
field=video
wrap = <div class="play"><a href="http://|" target="_blank"><img src="fileadmin/templates/images/button_play.gif" alt="PLAY" width="58" height="15" border="0"/></a></div>
}
}
10.wrap = <div class="lightbox">|</div>
}
}
}