1:

$sql = mysql_query ("SELECT * FROM hamburg WHERE plz LIKE '$search%' LIMIT 5")  or die(mysql_error() .'  Query: '.$sql);      if (mysql_num_rows($sql) == 0)  {  echo "  Es gibt leider keine Treffer zu Ihrer Suchanfrage!";  }    while($r=mysql_fetch_array($sql))  {  $name=$r["name"];  $strasse=$r["strasse"];  $plz=$r["plz"];  $ort=$r["ort"];  $pic=$r["pic"];  $url=$r["url"];  $telefon=$r["telefon"];    echo  " $name <br>  	$strasse<br>  		$plz $ort<br><br>  			Telefon: $telefon<br><br>      				<a href=$url><img src='images/webs.gif'></a><br><br><br>";  }