title: PHP variable returning NULL when the row from the SQL query contains data
body: <p>I am running an SQL query in PHP but the query returns NULL for one of the fields.</p>
  
  <pre><code>$sql = "SELECT * FROM `products` WHERE `product_id` = ".$product_id;
  $result = $conn-&gt;query($sql);
      if ($result-&gt;num_rows &gt; 0) {
          while($row = $result-&gt;fetch_assoc()){
              $product_name = $row['name'];
              $product_price = $row['price'];
              $product_category = $row['category'];
              $notes = $row['notes'];
              echo $notes;
              $temp_array = array($product_id,$product_name,$product_price,$product_category,$product_quantity,$notes,$current_order,$current_order_id);
              array_push($item,$temp_array);  
          }
  </code></pre>
  
  <p>The field that returns null is notes. I have double and triple checked to see if the field name is notes and whether there was any data in that field. The SQL table looks as follows:
  * Note: there is definitely and some text are the strings stored in the table.</p>
  
  <pre><code>+ Options
   Full texts 
  order_id
  product_id
  customer_id
  quantity
  date
  notes
  
  Edit Edit
   Copy Copy
   Delete Delete
  96
  49
  55
  12
  2016-11-06
  there is definitely
  
  Edit Edit
   Copy Copy
   Delete Delete
  104
  53
  56
  3
  2016-11-07
  some text
  </code></pre>
  
  <p>When i echo all the other fields I recieve the values. The only difference between the fields I can see is that the rest are integer data types and date data types whereas the notes field is varchar (32).</p>
  
  <p>I have echoed the query and run it in PHP my admin and it returns all the data there correctly. </p>
  
  <p>Im not sure what I am doing wrong and any help would be appreciated.</p>