title: MySQL querying table - Doesn't show first result
body: <p>I have a DB (quartos) created with the following structure:</p>
  
  <pre><code>id_quarto  tipo_quarto  vista_quarto |
  a      Single   Mar | 
  b      Single   Mar |
  c      Single   Mar | 
  d      Single   Serra |
  </code></pre>
  
  <p>I want it to return the results of id_quarto, when tipo_quarto=Single and vista_quarto=Mar which values come from a form.</p>
  
  <p>So i write the following:</p>
  
  <pre><code>$strSQL = "
  SELECT id_quarto 
  FROM quartos 
  WHERE tipo_quarto='". $_POST['tipo_quarto'] ."' 
      AND vista_quarto='". $_POST['vista_quarto'] ."'";
  $rs = mysql_query($strSQL);
  $row = mysql_fetch_array($rs);
  </code></pre>
  
  <p>Then i loop it and write in a table as followed:</p>
  
  <pre><code>while($row = mysql_fetch_array($rs)) {
  &lt;?
  &lt;table border="1"&gt;
       &lt;tr align="left"&gt;
           &lt;td width="75"&gt;&lt;?php echo $row['id_quarto']; ?&gt;&lt;/td&gt;
       &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>The problem here is that it does not return the id_quarto=a , only b and c. Why is that and what can i do to fix it?</p>
  
  <p>Thanks.</p>