If you want to highlight the EXACT search string, do a str_replace() on
$row["Description"], $row["ProductName"], etc etc, replacing the search
phrase with $searchSite. Pretty simple.
$siteSearch",
$row["Description"]);
$productName = str_replace($siteSearch, "$siteSearch",
$row["ProductName"])
Hi James
I'll paste the code I use..
$string = search string entered in the text box.
#
// REPLACE SPACES FOR MULTIWORD SEARCH
$string = str_replace(" ","%",$string);
$db->query("SELECT title,description FROM files WHERE (title LIKE
'%
> The input from the search form is $searchtext. The Returned
> Search data is
> $searchdata.
>
>
> $sql = "SELECT searchdata FROM table WHERE searchdata LIKE
> '%$searchtext'";
> $result = @mysql_query($sql, $connection)
> or die (mysql_error());
>
> $num = mysql_num_rows($result);
>
> $x
3 matches
Mail list logo
