Wer findet den Fehler im PHP Script?

<?

//Datenbankverbindung 
$host = "localhost";   
$host_user = "root";   
$host_password = "testpw";   
$host_db = "itdb";   

$link = mysql_connect("$host", "$host_user", "$host_password")or die("Fehler beim verbinden!");  
mysql_select_db($host_db, $link)or die("Kann keine Verbindung mit der Datenbank herstellen!");  

?> 

<form action="<?php echo $erfolgreich; ?>" method="post">  

<?
include("config.php");  

if(isset($_POST["submitted"])) {  
	$_sql = "UPDATE geraete';  
	$_sql .= " SET kunde='".$_POST["kunde"]."'";  
	$_sql .= " SET benutzer='".$_POST["benutzer"]."'";  
	$_sql .= " SET typ='".$_POST["typ"]."'";  
	$_sql .= " SET hostname='".$_POST["hostname"]."'";  
	$_sql .= " SET benutzer='".$_POST["benutzer"]."'";  
	$_sql .= " SET hersteller='".$_POST["hersteller"]."'";  
	$_sql .= " SET prod_bez='".$_POST["prod_bez"]."'";  
	$_sql .= " SET prod_nr='".$_POST["prod_nr"]."'";  
	$_sql .= " SET sn='".$_POST["sn"]."'";  
	$_sql .= " SET spare_nr='".$_POST["spare_nr"]."'";  
	$_sql .= " SET service_tag='".$_POST["service_tag"]."'";  
	$_sql .= " SET expr_tag='".$_POST["expr_tag"]."'";  
	$_sql .= " SET kauf_dat='".$_POST["kauf_dat"]."'";  
	$_sql .= " SET liefer_dat='".$_POST["liefer_dat"]."'";  
	$_sql .= " SET garantie='".$_POST["garantie"]."'";  
	$_sql .= " SET domain='".$_POST["domain"]."'";  
	$_sql .= " SET mac='".$_POST["mac"]."'";  
	$_sql .= " SET ip='".$_POST["ip"]."'";  
	$_sql .= " SET subnet='".$_POST["subnet"]."'";  
	$_sql .= " SET gateway='".$_POST["gateway"]."'";  
	$_sql .= " SET dns='".$_POST["dns"]."'";  
	$_sql .= " SET dns2='".$_POST["dns2"]."'";  
	$_sql .= " SET team_id='".$_POST["team_id"]."'";  
	$_sql .= " SET team_pass='".$_POST["team_pass"]."'";  
	$_sql .= " SET comments='".$_POST["comments"]."'";  
	$_sql .= " WHERE id='".$_POST["id"]."'";  
	mysql_query($_sql,$link);
} else {
	$abfrage ='SELECT * FROM geraete WHERE id=1';     
	$ergebnis = mysql_query($abfrage);  
	   
		while ($geraete= mysql_fetch_array($ergebnis))
		
		{
		
			$id = $geraete["id"];  
			$kunde = $geraete["kunde"];  
			$benutzer = $geraete["benutzer"];  
			$typ = $geraete["typ"];  
			$hostname = $geraete["hostname"];  
			$hersteller = $geraete["hersteller"];  
			$prod_bez = $geraete["prod_bez"];  
			$prod_nr = $geraete["prod_nr"];  
			$sn = $geraete["sn"];  
			$spare_nr = $geraete["spare_nr"];  
			$service_tag = $geraete["service_tag"];  
			$expr_tag = $geraete["expr_tag"];  
			$kauf_dat = $geraete["kauf_dat"];  
			$liefer_dat = $geraete["liefer_dat"];  
			$garantie = $geraete["garantie"];  
			$domain = $geraete["domain"];  
			$mac = $geraete["mac"];  
			$ip = $geraete["ip"];  
			$subnet = $geraete["subnet"];  
			$gateway = $geraete["gateway"];  
			$dns = $geraete["dns"];  
			$dns2 = $geraete["dns2"];  
			$team_id = $geraete["team_id"];  
			$team_pass = $geraete["team_pass"];  
			$comments = $geraete["comments"];  
?>

<table>
	<tr>
		<td valign="top"><input type="hidden" name="id" size="35" value="<?php echo $id; ?>"></td>  
	</tr>
	<tr>
		<td>Kunde:</td>
  		<td valign="top"><input type="text" name="kunde" size="35" value="<?php echo $kunde; ?>"></td>  
  	</tr>
  	<tr>
  		<td>Benutzer:</td>
		<td valign="top"><input type="text" name="benutzer" size="35" value="<?php echo $benutzer; ?>"></td>  
	</tr>
	<tr>
		<td>Typ:</td>
		<td>
			<select name="typ" size="1" style="width: 237px">  
				<option selected=""><?php echo $typ; ?></option>  
				<option>PC</option>
				<option>Notebook</option>
				<option>Server</option>
			</select>
		</td>
	</tr>
	<tr>
		<td>Hostname:</td>
		<td valign="top"><input type="text" name="hostname" size="35" value="<?php echo $hostname; ?>"></td>  
	</tr>
	<tr>
		<td>Hersteller:</td>
		<td valign="top"><input type="text" name="hersteller" size="35" value="<?php echo $hersteller; ?>"></td>  
	</tr>  
	<tr>
		<td>Produkt Bezeichnung:</td>
		<td valign="top"><input type="text" name="prod_bez" size="35" value="<?php echo $prod_bez; ?>"></td>  
	</tr>
	<tr>
		<td>Produkt Nummer::</td>
		<td valign="top"><input type="text" name="prod_nr" size="35" value="<?php echo $prod_nr; ?>"></td>  
	</tr> 
	<tr>
		<td>Seriennummer:</td>
		<td valign="top"><input type="text" name="sn" size="35" value="<?php echo $sn; ?>"></td>  
	</tr> 
	<tr>
		<td>Spare Nummer:</td>
		<td valign="top"><input type="text" name="spare_nr" size="35" value="<?php echo $spare_nr; ?>"></td>  
	</tr>   
	<tr>
		<td>Service Tag:</td>
		<td valign="top"><input type="text" name="service_tag" size="35" value="<?php echo $service_tag; ?>"></td>  
	</tr>   
	<tr>
		<td>Express Service Tag:</td>
		<td valign="top"><input type="text" name="expr_tag" size="35" value="<?php echo $expr_tag; ?>"></td>  
	</tr>    
	<tr>
		<td>Kauf Datum:</td>
		<td valign="top"><input type="text" name="kauf_dat" size="35" value="<?php echo $kauf_dat; ?>"></td>  
	</tr>   
	<tr>
		<td>Liefer Datum:</td>
		<td valign="top"><input type="text" name="liefer_dat" size="35" value="<?php echo $liefer_dat; ?>"></td>  
	</tr>   
	<tr>
		<td>Garantie bis:</td>
		<td valign="top"><input type="text" name="garantie" size="35" value="<?php echo $garantie; ?>"></td>  
	</tr>   
	<tr>
		<td>Domäne:</td>
		<td valign="top"><input type="text" name="domain" size="35" value="<?php echo $domain; ?>"></td>  
	</tr>    
	<tr>
		<td>MAC-Adresse:</td>
		<td valign="top"><input type="text" name="mac" size="35" value="<?php echo $mac; ?>"></td>  
	</tr>  
	<tr>
		<td>IP-Adresse:</td>
		<td valign="top"><input type="text" name="ip" size="35" value="<?php echo $ip; ?>"></td>  
	</tr>  
	<tr>
		<td>Subnet-Maske:</td>
		<td valign="top"><input type="text" name="subnet" size="35" value="<?php echo $subnet; ?>"></td>  
	</tr>  
	<tr>
		<td>Standard-Gateway:</td>
		<td valign="top"><input type="text" name="gateway" size="35" value="<?php echo $gateway; ?>"></td>  
	</tr>  
	<tr>
		<td>DNS:</td>
		<td valign="top"><input type="text" name="dns" size="35" value="<?php echo $dns; ?>"></td>  
	</tr>  
	<tr>
		<td>Alternativer DNS:</td>
		<td valign="top"><input type="text" name="dns2" size="35" value="<?php echo $dns2; ?>"></td>  
	</tr>  
	<tr>
		<td>Teamviewer ID:</td>
		<td valign="top"><input type="text" name="team_id" size="35" value="<?php echo $team_id; ?>"></td>  
	</tr> 
	<tr>
		<td>Teamviewer Passwort:</td>
		<td valign="top"><input type="text" name="team_pass" size="35" value="<?php echo $team_pass; ?>"></td>  
	</tr> 
	<tr>
		<td>Kommentare:</td>
		<td> <textarea name="comments" cols="27" rows="15"><?php echo $comments; ?></textarea> </td>  
	</tr>             
</table>

<?php
  		  }		  
mysql_close($link);   
?>

<input type="submit" name="submitted" value="&Uuml;bernehmen">  
</form>

<?

	}
	
?>