Code: Select all
$params['searchinput'] = $_POST['searchinput'];
$word = htmlspecialchars(trim($params['searchinput']));
$sql = 'SELECT DISTINCT * FROM '.cms_db_prefix().'module_search_index WHERE word LIKE ? LIMIT 20';
$result =& $db->Execute($sql,array($word."%"));
echo '<ul>';
while($result && $row = $result->FetchRow()) {
echo '<li>'.$row['word'].'</li>';
}
echo '</ul>';