Like Yahoo Search Results 1

[alsaffar]

Let's say I have a field called (Words) in a table called (Search) and the data in the (Words) field is "I LOVE PHP MORE THAN MY LIFE", so what I want is, when I qurey the DB:

SELECT Words FROM Search WHERE Words like '%LOVE%'

I want the word(s) that I'm qureing on to be highlited or colored in the results on my php page, (e.g. Like if you search Yahoo, all the words you're searching in the results will be bolded)

How can I achieve my goal? Remeber that the (Words) field have more that the word that Im seraching, how can I highlight only the serach keyword? so the result will be like the following:

I LOVE PHP MORE THAN MY LIFE.

Please help me guys

 

[skiflyer]

Do a preg_replace()

In your example you'd just replace
love with

<b>love</b>

Regular expressions can do matching so this is fairly easy.

http://www.php.net/manual/en/function.preg-replace.php

(Notice in the left column there are links helping you setup the patterns)

-Rob