Description

 Creates an auto complete Form Field where you can search content from any table in the database.

Requirement

  1.  Have watched the Form Fields -> Basic Features screencast.

Usage

 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

Code Example

SELECT title AS value
FROM #__content
WHERE state=1
AND title LIKE '%{selectresult}%'
ORDER BY title ASC