problem with my search engine...

[AviNahum]

hey (sorry for very poor English... i from Israel)

i tried to make a search engine to my website...

but i got a problem...

when i typing something in English its works...

but my web in Hebrew (i from Israel)

and when i typing something in Hebrew its don't find anything...

and its don't showing any errors...

this is my php code:

$search=$_GET['search'];
$where_to_search=$_GET['where_to_search'];

if($where_to_search=='downloads') {

	$query="SELECT * FROM `web_downloads` WHERE title LIKE '%$search%' AND depiction LIKE '%$search%' ORDER BY id DESC";
	$relust=mysql_query($query);
	while ($r=mysql_fetch_assoc($relust)) {

		if ((mysql_num_rows($relust))==0) {

			echo "no results";
		}

		else {

			echo $r['title'];

		}



	}
}

elseif ($where_to_search=='articles') {

$query="SELECT * FROM `web_articles` WHERE title LIKE '%$search%' AND depiction LIKE '%$search%' ORDER BY id DESC";
$relust=mysql_query($query);
while ($r=mysql_fetch_assoc($relust)) {

	if ((mysql_num_rows($relust))==0) {

			print "no results";
		}

		else {

			echo $row['title'];

		}

	}
}

 

thanks!

[Mr_J]

can u provide the link please

[AviNahum]

http://avi.one-serv.net/ms/

this is the link but again it's in hebrew

[redarrow]

What does Hebrew sentence look like please.

 

You will need to use mysql_real_ecsape_string() i guess

[AviNahum]

and do you know where i can find a free php search engine script?