title: fetch_array with prepared statement? PHP MYSQL?
body: <p>For some reason I cannot get this to work for the life of me, I am new to prepared statements!</p>
  
  <p><pre><code>
      $q = $dbc -> prepare ("SELECT * FROM accounts WHERE email = ? &amp;&amp; logcount = ''");
      $q -> bind_param ('s', ($_SERVER['QUERY_STRING']));
      $row = $q -> fetch_array(MYSQLI_ASSOC);
      $q -> execute();
      $q -> store_result();
          if ($q -> num_rows == 1) {
              $q = $dbc -> prepare("UPDATE accounts SET logcount = '0' WHERE email = ?");
              $q -> bind_param('s', ($_SERVER['QUERY_STRING']));
              $q -> execute();
              echo '<p>Congratulations ' . $row['username'] . ' your account is now active!</p>';
          }</pre></code></p>
  
  <p>Any ideas why $row['username'] will not print? It returns a :
  Call to undefined method mysqli_stmt::fetch_array()</p>
  
  <p>Thanks.</p>