title: Having trouble executing a SELECT query in a prepared statement
body: <p>Ive followed a bunch of different examples regarding using a SELECT in a prepared statement, but nothing is returned. 
  <em>EDIT</em> I have changed my code a bit to look like this:</p>
  
  <pre><code>$date1 = 2012-01-01;
  $date2 = 2012-01-31;
  $sql_con = new mysqli('db', 'username', 'password', 'database');
  
  if($stmt = $sql_con-&gt;prepare("SELECT eventLogID FROM Country WHERE countryCode=? AND date BETWEEN ? AND ?")){
  
     $stmt-&gt;bind_param("sss", $country_code, $date1,$date2); 
  
      $stmt-&gt;execute();
  
    $i=0;
    while ($stmt-&gt;fetch()){
    $stmt-&gt;bind_result($row[$i]);
    $i++;
    }
  
    $stmt-&gt;close();
  $sql_con-&gt;close();
  </code></pre>
  
  <p>Now all the desired entries, except for the first, are added to $row[]. Why isnt the first entry being added?
  Thanks in advance!</p>