highlighting searched characters

[envexlabs]

i have my search function:

 

function perform_search($search, $table){

        //if white pages is selected
        $search_query = mysql_query('SELECT * FROM `entries` WHERE `' . $table . '` LIKE "%' . $search .'%"') or die(mysql_error());
        $info = mysql_fetch_row($search_query);
        return $info;
        
}

 

So if someone searches att, it will come back with a database result of matt or anything containing att.

 

Is there a way to highlight the search value $search?

 

ie:

 

att is searched

 

matt

 

attitude

 

come back, att is bolded.

[kathas]

a simple one would be...

<?php

// supposing that $result is the string that has 'att' in
// also supposing that $search_str = 'att';

$result = str_replace($search_str,'<span class="highlight">'.$search_str.'</span>',$result);

echo $result; //now higlighted if you have added the css to make <span class="highlight"> highlighted
?>