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:
- Alto
- Amaze
- Wagon r
- swift
- i10
- santro
Then if a user types in a
- it should display matching results (Alto
, Amaze
)