Get User ID from Select List

mauriestate
Topic Author
Offline
Premium Member

11 years 8 months ago #41315 by mauriestate

Get User ID from Select List was created by mauriestate

Hi,

Following this FAQ ( www.flexicontent.org/documentation/faq/7...to-contact-form.html ) we can show contact details of a specific user from the select list, that is, the SQL function

Code:

SELECT id as value, name as text FROM #__contact_details WHERE user_id="{item->created_by}"

retrieves the user contact details from the database.

Based on this, I only need to get the user ID from the default Joomla user database, what is the SQL function should I use please? Sorry, I am not that good with SQL.

Offering professional real estate and investment services in Mauritius. Visit us at www.sjkestate.com to also see the power of Flexicontent with Joomla to promote our services.

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

ggppdk
Offline
Administrator

11 years 8 months ago #41320 by ggppdk

Replied by ggppdk on topic Get User ID from Select List

Hello

the user id of current item owner is:
{item->created_by}

-- and you used the above use id to get the contact details

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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