Bolding results....

[rulinus]

hi, I was wondering if any one could help me.
I have placed a search for mysql DB and i wanted to bold the results that match the search string. So if for example, you searched "rock", the results would show rock all over the rows.
Any help would be appreciated

[eoghain]

Run your results through a regular expression:

$results = preg_replace($search, '<b>' . $search . '</b>', $result);

That will work, except for things like rocky which will show up as rocky. But it gives you a place to start. Look at the manual for [man]preg_replace/man and I'm sure you'll be able to figure it out.

[rulinus]

hi, thank you for the input.
I used it and i get an error like this:
Warning: Delimiter must not be alphanumeric or backslash
in /home/coyoacan/public_html/data/results.php on line 57
my code is:

<? 
 if ($search)   // perform search only if a string was entered. 
   { 
 	switch ($tipo)
	{
	case "artisata":
    	mysql_connect("localhost", "coyoacan_rulo", "paswrd" ) or die ("Problem connecting to DataBase"); 
    	$srch="%".$search."%"; 
    	$query = "select * from musica WHERE artista LIKE '$srch'"; 
    	$result = mysql_db_query("coyoacan_prueba", $query); 
				$prob=mysql_error(); 
		$total = mysql_num_rows($result); 
   		break;
	case "disco":
		mysql_connect("localhost", "coyoacan_rulo", "paswrd" ) or die ("Problem connecting to DataBase"); 
    	$srch="%".$search."%"; 
    	$query = "select * from musica WHERE discos LIKE '$srch'"; 
    	$result = mysql_db_query("coyoacan_prueba", $query); 

	$prob=mysql_error();
	$total = mysql_num_rows($result);
	break;
case "cancion":
	mysql_connect("localhost", "coyoacan_rulo", "paswrd" ) or die ("Problem connecting to DataBase"); 
	$srch="%".$search."%"; 
	$query = "select * from musica WHERE canciones LIKE '$srch'"; 
	$result = mysql_db_query("coyoacan_prueba", $query);

	$prob=mysql_error();
	$total = mysql_num_rows($result);
	break;
case "genero":
	mysql_connect("localhost", "coyoacan_rulo", "paswrd" ) or die ("Problem connecting to DataBase"); 
	$srch="%".$search."%"; 
	$query = "select * from musica WHERE genero LIKE '$srch'"; 
	$result = mysql_db_query("coyoacan_prueba", $query);
			$prob=mysql_error();
	$total = mysql_num_rows($result);
	break;
default :  
	mysql_connect("localhost", "coyoacan_rulo", "paswrd" ) or die ("Problem connecting to DataBase");  
	$srch="%".$search."%"; 
	$query = "select * from musica WHERE artista LIKE '$srch' || bio LIKE '$srch' || discos LIKE '$srch' || canciones LIKE '$srch' || genero LIKE '$srch'"; 
	$result = mysql_db_query("coyoacan_prueba", $query);
	$prob=mysql_error();
	$total = mysql_num_rows($result);
	break;
	}
if  ($result)  

I tried replecing the $search after each query in each case, after the "$result = mysql_db_query("coyoacan_prueba", $query);"

I'm stuck.

[eoghain]

[man]preg_replace/man needs to have it's search string delimited. So you'd need to change my code to look more like this:

$result = preg_replace("/" . $search . "/", "<b>" . $search . "</b>", $result);

You should really read up on how to use [man]preg_replace/man if you want to use it correctly. My code is only an example do some research and you should be able to figure out how to impliment it in your script.