article title + icon in select field

More
6 years 8 months ago #72739 by aminweb
Replied by aminweb on topic article title + icon in select field
please see my screen & senario.

1- I have a one field (select) by name HotelName this field`s value load by sql query by this syntax:(load article title in category id 10)

pasteboard.co/HfbcH8x.jpg
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)
2- when user submission items , select fields show title of article in catid=10

pasteboard.co/HfbsX6C.jpg

3- Now,after submission I want this value linked to article.when user click on value(title) redirect to article

pasteboard.co/Hfbvqhc.jpg


please help me.sooooo thanks

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

More
6 years 8 months ago #72740 by micker
Replied by micker on topic article title + icon in select field
that i explain must worked ...
read this to inspiration
flexicontent.org/documentation/faq/71-fi...s-to-a-category.html
flexicontent.org/documentation/faq/71-fi...to-contact-form.html
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]
The following user(s) said Thank You: aminweb

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

More
6 years 8 months ago #72741 by aminweb
Replied by aminweb on topic article title + icon in select field
this tutorials for category & contact linked.
How to create a field that links to a category & contact

but I want linked to article

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

More
6 years 8 months ago #72742 by micker
Replied by micker on topic article title + icon in select field
i already explain it !! please adapt
Code:
index.php?option=com_flexicontent&view=item&id=
id=YOURVALUEINSQL
that create a link to your item
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.

More
6 years 8 months ago #72743 by aminweb
Replied by aminweb on topic article title + icon in select field
ohhhhhh.
I'm confused :(

I get only the title(NOT ID) of every article with these codes.
now how get id of articles???

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

More
6 years 8 months ago #72744 by micker
Replied by micker on topic article title + icon in select field
in you field you can set value or id
=> read faq above
5. as Frontend Display
select "value" instead of "text"
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.

Moderators: vistamedia, joomlacorner, ggppdk
Time to create page: 0.782 seconds

Last FLEXI-site

Last Faq articles

Newsletter

Last Tutos about FLEXIcontent

Login

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline