title: SELECT statement with fetch_array in mysqli prepared statements
body: <p>I always find it difficult to write MySQLi prepared statements, because many functions work differently than in the old way. Right now I am facing a problem regarding <code>fetch_array()</code>.</p>
  
  <pre><code>$stmt = $db-&gt;prepare("SELECT category_id FROM post_items Where user_id = ?");
  $stmt-&gt;bind_param('i', $userid);
  $result = $stmt-&gt;execute();
  while ($row = $result-&gt;fetch_array()) {
      // ...
  }
  </code></pre>