Creates an auto complete Form Field where you can search content from any table in the database.
Select Components → Contact Enhanced → Form Fields from the drop-down menu on the back-end of your Joomla! installation, then Select AutoComplete from the Field Type select list;
Choose a category for your Form Field, then Save the changes.
Add a SQL query to the value. The SQL Query must return one column only and the column name OR alias must be "value". Use {selectresult} as the text to search for
SELECT title AS valueRecommend to a friend
FROM #__content
WHERE state=1
AND title LIKE '%{selectresult}%'
ORDER BY title ASC
Copyright © 2018 IdealExtensions.com. All Rights Reserved.