and keywords field have comma separated values entered by user.
In my live search script only first value from this keyword field is considered as a value.
here is the code
$query = $db->query("SELECT value, url, keywords FROM my_DB WHERE keywords LIKE '$queryString%' LIMIT 10");
if($query) {
while ($result = $query ->fetch_object()) {
$strUTF = iconv('cp1250','UTF-8',$result->value);
echo '<a class="bodyText" href="'.$result->url.'"><li onClick="fill(\\''.$strUTF.'\\');">'.$strUTF.'</a></font></li>';
}
}
how to iterate trough each keword field to be considered by script not just first one.
$sql = "SELECT value, url, keywords FROM my_DB WHERE (keywords LIKE '$queryString%' ) OR (value LIKE '$queryString%') OR ( url LIKE '$queryString%' ) LIMIT 10";