article title + icon in select field

aminweb
Topic Author
Offline
Premium Member

6 years 8 months ago - 6 years 8 months ago #72727 by aminweb

article title + icon in select field was created by aminweb

hi,
I create a select field for hotel name. and use sql query for load article title in hotel category(id=10) :

Code:

SELECT DISTINCT id as value, title as text
 FROM #__content AS i
 JOIN #__flexicontent_cats_item_relations AS rel
  ON rel.itemid = i.id AND rel.catid= 10
 WHERE i.state IN (1, -5)

now I have 2 problem:
1 - how value this field(hotel name) linked to article?
2- how show hotel star grade icon in value field?

like this :
www.booking.com/searchresults.en-gb.html...idr=1&;ilp=1;d_dcp=1

please help me
so thanks

Last edit: 6 years 8 months ago by aminweb.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

6 years 8 months ago #72728 by micker

Replied by micker on topic article title + icon in select field

why you didn't relation field ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

aminweb
Topic Author
Offline
Premium Member

6 years 8 months ago #72729 by aminweb

Replied by aminweb on topic article title + icon in select field

becuse can not use releation field in field group

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

6 years 8 months ago #72730 by micker

Replied by micker on topic article title + icon in select field

ok you need to use prefix and suffix to create your render ...
1 use remove space option
2 use html in prefix, like <a href="yourlink....=
3 finishing html link in suffix " class="yourclass"> your texte </a>
read popup description for more information

The following user(s) said Thank You: aminweb

Please Log in or Create an account to join the conversation.