title: MySQLi / PHP - Pulling data from one database. Inserting into another database
body: <p>Trying to pull data out of a basic phpmyadmin database.</p>
  
  <p>The code below pulls the data correctly (Commented out section verify).
  I can write it to the screen and display it. (Not needed just testing)
  Trying to insert it into another database however and it fails.</p>
  
  <p>I've discovered that the while loops for inserting do not run. Although I can not find out why.</p>
  
  <p>It's a basic localhost database (Testing right now) So the connect data is just temporary.</p>
  
  <p>Any assistance is greatly appreciated
  Thanks.</p>
  
  <pre><code>&lt;?php
  
  /*
    Connect to database
   */
  $webhost = 'localhost';
  $webusername = 'root';
  $webpassword = '';
  $webdbname = 'transfertest';
  $webcon = mysqli_connect($webhost, $webusername, $webpassword, $webdbname);
  if (mysqli_connect_errno()) {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  /*
   * 
   */
  $questions = mysqli_query($webcon, "SELECT * FROM questions");
  $scenarios = mysqli_query($webcon, "SELECT * FROM scenarios");
  $results = mysqli_query($webcon, "SELECT * FROM results");
  $employees = mysqli_query($webcon, "SELECT * FROM employees");
  /*
   * These while loops display the content being pulled from the database correctly.
  while ($row = mysqli_fetch_array($questions)) {
      echo $row['questionID'] . " : " . $row['question'] . " : " . $row['answers'];
      echo "&lt;/br&gt;";
  }
  while ($row = mysqli_fetch_array($scenarios)) {
      echo $row['scenarioID'] . " : " . $row['scenarioTitle'] . " : " . $row['scenarioInformation'];
      echo "&lt;/br&gt;";
  }
  while ($row = mysqli_fetch_array($results)) {
      echo $row['employeeID'] . " : " . $row['scenarioID'] . " : " . $row['questionID'] . " : " . $row['answers'] . " : " . $row['correct'];
      echo "&lt;/br&gt;";
  }
  while ($row = mysqli_fetch_array($employees)) {
      echo $row['employeeID'] . " : " . $row['firstName'] . " : " . $row['lastName'] . " : " . $row['email'] . " : " . $row['password'];
      echo "&lt;/br&gt;";
  }
   */
  /* //////////////////////////////////////////////////////////////////////////
    Connect to database
   */
  $mobhost = 'localhost';
  $mobusername = 'root';
  $mobpassword = '';
  $mobdbname = 'exampletransfer';
  $mobcon = mysqli_connect($mobhost, $mobusername, $mobpassword, $mobdbname);
  if (mysqli_connect_errno()) {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  /*
   * 
   */
  while ($row = mysqli_fetch_array($questions)) {
      mysqli_query($mobcon, "INSERT INTO questions (questionID, question, answers) VALUES (" . $row['questionID'] . ", " . $row['question'] . ", " . $row['answers'] . ")");
  }
  while ($row = mysqli_fetch_array($scenarios)) {
      mysqli_query($mobcon, "INSERT INTO scenarios (scenarioID, scenarioTitle, scenarioInformation) VALUES (" . $row['scenariosID'] . ", " . $row['scenarioTitle'] . ", " . $row['scenarioInformation'] . ")");
  }
  while ($row = mysqli_fetch_array($results)) {
      mysqli_query($mobcon, "INSERT INTO results (employeeID, scenarioID, questionID, answers, correct) VALUES (" . $row['employeesID'] . ", " . $row['scenariosID'] . ", " . $row['questionID'] . ", " . $row['answers'] . ", " . $row['correct'] . ")");
  }
  while ($row = mysqli_fetch_array($employees)) {
      mysqli_query($mobcon, "INSERT INTO employees (employeeID, firstName, lastName, email, password) VALUES (" . $row['employeesID'] . ", " . $row['firstName'] . ", " . $row['lastName'] . ", " . $row['email'] . ", " . $row['password'] . ")");
  }
  /*
    Close Connections
   */
  mysqli_close($webcon);
  mysqli_close($mobcon);
  /*
   * Error code:
  Notice: Undefined index: scenariosID on line 75
  
  Notice: Undefined index: employeesID on line 78
  
  Notice: Undefined index: scenariosID on line 78
  
  Notice: Undefined index: employeesID on line 81
   */
  ?&gt;
  </code></pre>