[SOLVED] depend on query result display different icon

hallo there,

i am trying to figure out a way to achieve this:

i want to create a query field which will count a number of my database. i know that i cannot insert php in the query, but i need somehow to differate 4 cases in order to display for each case differnet icon.

thank you

Create a CB Query Field that queries for your count then use a substitution IF statement in a Custom HTML field to condition against the query fields value. Example as follows.

[cb:if FIELD_NAME="1"]Icon 1[/cb:if]
[cb:if FIELD_NAME="2"]Icon 2[/cb:if]
[cb:if FIELD_NAME="3"]Icon 3[/cb:if]
[cb:if FIELD_NAME>"3"]Icon 4[/cb:if]

You can also use this in the query fields Parameters > Layout > Profile Value Layout to avoid needing a Custom HTML field to handle the profile display. See the below for further substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

hi kyle,

i have no words..cb is keeping to surprise me..everything i can think is always possible!

i use the profile value layout and it works perfect!

thank you very much