title: Query not displaying all results from MySQL database
body: <p>bit confused here with what's wrong with my query. I have about 9 records and am trying to get all this 9 records from MySQL database. The weird thing happening is only 2 of the records are coming out and I really don't understand what's going on as my query seems to be Ok.</p>
  
  <pre><code>$mQ = "SELECT * FROM group_elective_modules 
          WHERE group_elective_modules.yr = '4' 
          AND 
          group_elective_modules.courseName = 'BSCSHCSSEntrepreneurship' ";
  $mR = mysql_query($mQ);
  while ($ROW = mysql_fetch_array($mR)) {                                                                 
      echo $ROW['moduleID'] . "&amp;nbsp;&amp;nbsp;". $ROW['yr'] . "&lt;BR /&gt;";
  }
  </code></pre>
  
  <p>Here's the table <img src="https://i.stack.imgur.com/ha54C.png" alt="enter image description here"></p>
  
  <p>Any help would be appreciated as I don't understand what's going on with this query. Thanks in advance.</p>