[HaBo]

Ungültige Abfrage: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE `Handy` SET `Beschreibung` = 'DESC' WHERE `Handy`.`Handy_ID` =1; UPDATE' at line 1

  if($_POST['Edit'])
  {
  	echo $_POST['AnzahlHandy'];
  	echo $_POST['AnzahlExtra'];
  	echo "yyaaaaaaaaa";

  	$i=1;
  	while($i<=$_POST['AnzahlHandy']){
	    $sql =
    		"UPDATE `Handy` SET `Name` = '".$_POST['HandyName_'.$i]."' WHERE `Handy`.`Handy_ID` =".$i."; ".
    		"UPDATE `Handy` SET `Beschreibung` = '".$_POST['HandyBeschreibung_'.$i]."' WHERE `Handy`.`Handy_ID` =".$i."; ";
    	$x=1;
    	while($x<=20){
      	$sql = $sql.
	      	"UPDATE `Handy` SET `InfoName".$x."_".$i."` = '".$_POST['HandyInfoName'.$x.'_'.$i]."' WHERE `Handy`.`Handy_ID` =".$i."; ".
      		"UPDATE `Handy` SET `InfoText".$x."_".$i."` = '".$_POST['HandyInfoText'.$x.'_'.$i]."' WHERE `Handy`.`Handy_ID` =".$i."; ";
      		$x++;
    	}
    	$i++;
  	}
  }

  echo "<br>".$sql."<br><b><font color='red'>";

  $result=mysql_query($sql);
  if (!$result) {
    die('Ungültige Abfrage: ' . mysql_error());
  }

  echo"</b></font>";