title: Value returned from mysqli db call in php doesn't return values with newline chara
body: <p>Ok so for some reason when I try and get values from a cell in my table with type TEXT it returns nothing, even thought there is text in the cell. It might be because there are new line characters in the text.  In fact I'm certain that's the reason cause the only time things aren't return from the table is when there are newlines in it.</p>
  
  <p>Here is the code where I get the data from my db:</p>
  
  <pre><code>function getRecord($cmo_name,$username,$password){
    $i = 0;
  
      $servername = "localhost";
      $db = "my_db";
  
      $return_array[] = "";
  
      $conn = new mysqli($servername, $username, $password, $db);
      if ($conn-&gt;connect_error) {
        die("Connection failed: " . $conn-&gt;connect_error); 
      }  
  
      $sql = "SELECT * FROM `my_table` WHERE `Name` = '".$name."'";
      $result = $conn-&gt;query($sql);
  
      if ($result-&gt;num_rows &gt; 0) {
  
        while($row = $result-&gt;fetch_assoc()){
          foreach($row as $value)
            array_push($return_array, $value);}
      }
  
      $conn-&gt;close();
      return $return_array;
  }
  </code></pre>
  
  <p>The above code returns nothing for the TEXT column that includes the newlines.</p>
  
  <p>Help please!!!</p>