title: mysqli query in WHILE loop
body: <p>1.) Can you nest a msqli_query inside a while loop?</p>
  
  <p>2.) If yes, why would the PHP below not write any data to the precords table?</p>
  
  <p>If I echo a $build array variable it shows properly, but the mysqli insert writes nothing to the table in the DB. THe code does not error out anywhere, so what am I missing about this?</p>
  
  <pre><code>$data = mysqli_query($con,"SELECT * FROM Cart WHERE Buyer_ID='$_SESSION[cid]' AND Cart_Date='$_SESSION[cdate]'");
  while($build = mysqli_fetch_array($data))
  { 
  //echo $build[idex]."&lt;br&gt;";
  mysqli_query($con,"INSERT INTO precords (precord,Buyer_ID,Account,Purchase_Date,Item_Number,Item_Qty,Item_Title,Item_FPrice,Item_FFLFlag,ccpass) VALUES ('$build[idex]','$build[Buyer_ID]','$build[Cart_Date]','$build[Item_Number]','$build[Item_Qty]','$build[Item_Title]','$build[Item_FPrice]','$build[Item_FFLFlag]','N')");
  };
  </code></pre>
  
  <p>Thanks for any help.</p>
  
  <p>** P.S. - This code is meant to move certain values from a TEMPORARY table/session variables, over to a permanent record table, but the loop is needed since there is more than one product in the cart associated with the user/session.</p>