nu reusesc sa fac un search sa functioneze

A MERS!!! YESS!!! MERSI WRATH

$query="(select titlu_continut,continut,id as res_id,'afisare_actualitate' as link from actualitate where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%') UNION (select titlu_continut,continut,id as res_id,'afisare_business' as link from business where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%') UNION (select titlu_continut,continut,id as res_id,'afisare_cultura' as link from cultura where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%') UNION (select titlu_continut,continut,id as res_id,'afisare_international' as link from international where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%') UNION (select titlu_continut,continut,id as res_id,'afisare_monden' as link from monden where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%')  UNION (select titlu_continut,continut,id as res_id,'afisare_politica' as link from politica where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%')  UNION (select titlu_continut,continut,id as res_id,'afisare_social' as link from social where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%') UNION (select titlu_continut,continut,id as res_id,'afisare_sport' as link from sport where  continut like '%".$searchterm."%' OR titlu_continut like '%".$searchterm."%')";
		$result=mysql_query($query);
			
		$num_results=mysql_num_rows($result);
		echo "<p>Numar rezultate: ".$num_results."</p>";
		for($i=0;$i<$num_results;$i++)
			{

				while($rand=mysql_fetch_array($result))
						{ 
							  echo "<img src='triangle.gif'> <a href=\"$rand[link].php?id=".$rand['res_id']."\">".stripslashes($rand['titlu_continut'])."</a><BR>";
							echo "<i>".substr(stripslashes($rand['continut']),0,150)."</i>...<BR>";			
						}
			}

sal
Poate sa ma ajute si pe mine cineva sa fac un search in baza de date deoarce am site-ul html
sau daca se poate asa ceva nu prea stiu mai nika despre php mai mult de instalat dar cu Mysql praf
Va Multumesc
Ma puteti gasi si pe id Man3l3
bafta All

google