title: Mysqli vs mysql, different result
body: <p>I have created a script local (Windows, xampp) and after checking everything if it works I moved it to a online server (Linux). Now I have a problem with collection results from my database. I have written everything using Mysqli, also with prepared statements and the first insert statement works perfect, but when I go to look at the results suddenly the program tells my he can't find the result.</p>
  
  <p>I've got a table: session with columns: ID, CreatedOn and Name
  When using the following lines of code i don't get any results</p>
  
  <pre><code>if ($stmt = $mysqli-&gt;prepare("SELECT ID, Name FROM `session` WHERE Name = ?;"))
  {
      $stmt-&gt;bind_param('s', $name);
      $stmt-&gt;execute();
  }
  </code></pre>
  
  <p>No results and no errors. The variable <code>$stmt-&gt;num_rows</code> have 0 as value. The variable $name contains: 'red'. when performing the query:</p>
  
  <pre><code>SELECT ID, Name FROM `session` WHERE Name = 'red';
  </code></pre>
  
  <p>In phpmyadmin I get the results I want, when I test the code using the orginal mysql functions (mysql_connect, mysql_query and mysql_fetch_assoc). I get the results that I want.</p>
  
  <p>Thus, the program is able to fetch the results that I want, only mysqli is not able to fetch them. I'm i doing something wrong? Or am i forgetting something?</p>