[TYPO3-english] Get count from database and display image based on count
Tomaž Lovrec
tomaz.lovrec at gmail.com
Sun Jul 21 21:51:35 CEST 2013
Hello,
I need to display an image, based on the count from the database. I've got my count out of the databse:
lib.unreadMessages = CONTENT
lib.unreadMessages {
table = tx_mmforum_pminbox
select {
selectFields = count(*) as msges
pidInList = 21
andWhere.data = TSFE:fe_user|user|uid
andWhere.wrap = to_uid=|
andWhere.20.data = 1
andWhere.20.wrap = read_flg=|
}
renderObj = COA
renderObj {
10 = TEXT
10 {
data = field:msges
}
}
}
And would like to display 2 different images, never both at the same time. One is when count is 0, and other, when count is greater than zero. Can this be done with typoscript alone? I'm running out of ideas.
Kind regards,
Thomas
More information about the TYPO3-english
mailing list