1:

where film like '%foo%'

1:

where film like '%foo hoo%'

1:

where film like '%foo%' or film like '%hoo%'

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31:

<form method="POST" action="suchen.php">
  <p>
  <input type="text" name="suche" size="20"><input type="submit" value="Abschicken" name="B1"></p>
</form>
<?
	$id = "xxx"; //mySQL Username
	$pw = "xxx"; //mySQL Passwort
	$host = "xxx";  //mySQL Hostname (meistens "LOCALHOST")
	$database = "xxx"; //Datenbankname
	$tablesvcd = "svcd"; //Tabellennamen

	$conn_id = mysql_connect($host,$id,$pw); 
	mysql_select_db($database,$conn_id); 

		$result = mysql_query("SELECT nr, film FROM $tablesvcd WHERE film LIKE '%$suche%' ORDER BY film");
		if ($suche ==""){echo("");} else
{
		if ($num = mysql_num_rows($result)) 
		{ 
    		// Ausgabe der Datensätze, wenn vorhanden 
			for($i=0;$i < $num; $i++) 
			{ 
			$nr = mysql_result($result,$i,"nr"); 
      			$film = mysql_result($result,$i,"film"); 
 
			echo "<a href=\"index.php?nr=$nr&info=zeigen\">$film</a>"; 
    			} 
  		} 
		else echo "<li>Leider ergab Ihre Suchanfrage kein Ergebnis."; 
}	
?>