Using below code to display database values as drop down in rsjoomla
$items = "|Please Select[c]\n"; $db = JFactory::getDBO(); $db->setQuery("SELECT id, prod_name FROM __used_products ORDER BY prod_sorder ASC"); $result = $db->loadObjectList(); if($result) foreach ($result as $r) $items .= $r->id . '|' . $r->prod_name . "\n"; return rtrim($items);
However - as the drop down is of more than 200 items, is there a way for a user to start typing a word and the select box only shows possible matches?
For example, the drop down field has the following options:
- Wagon r
Then if a user types in
a - it should display matching results (