title: insert into mysql db with php while loop
body: <p>I got the following issue while trying to insert multiple entries into a MySQL innodb.</p>
  
  <p>only the first insert is stored in the db. (although its stored correct)</p>
  
  <p>db data are correct, post data are correct, everything is tested
  the while loop is counting correct in my test (without the inserts)</p>
  
  <p>i.e. $r = 7 $s = 3 gives me 21 slots which is correct.</p>
  
  <pre><code>$l = $_POST['Lager'];
  $r = $_POST['Reihe'];
  $p = $_POST['platz'];
  $s = $_POST['slots'];
  $a = $_POST['art'];
  
  echo( "test: " . $_POST['Lager'] . $_POST['Reihe'] . $_POST['platz'] . $_POST['slots'] . $_POST['art'] );
  
  $i=0;
  $n=0;
  $counter =0;
  
  while($i &lt; $p)
  {
  $platz =("
   INSERT INTO 
      Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
   VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
   mysql_query($platz);
   echo ($platz);
  
      // anzahl slots = $s
      while($n &lt; $s)
      {
  
      $slot("
       INSERT INTO 
          Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
       VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
       mysql_query($slot) OR print(mysql_error());
  
      $n++;
      $counter++;
      echo($slot);
      }
      $n = 0;
  $i++;   
  }
    echo ("\n" . $counter . " Slots erstellt");
  </code></pre>
  
  <p>mysql_close();</p>