title: PHP- mysqli->num_rows always returns 0, Prepared statements
body: <p>First of all I would like to tell that I have already gone though <strong>ALL DUPLICATE</strong> questions. and tried the changes suggested there.</p>
  
  <p>As far as now I have already tried changing <code>num_rows</code> to <code>num_rows()</code>
  And using <code>store_result();</code> And using <code>affected_rows()</code>.</p>
  
  <p>Also calling <code>store_result();</code> after <code>execute()</code> </p>
  
  <p>I think there might be some other problem which I can't  figure out</p>
  
  <pre><code>$conn-&gt;autocommit(false);   
  if ($sucess){
      $stmt2 = $conn-&gt;prepare("UPDATE e_eventqueue SET e_urlfil=? WHERE e_id=? 
  AND u_id=?");
      $stmt2-&gt;bind_param("iis",$e_urlfil,$e_id,$u_id);
  
      if($stmt2-&gt;execute()){
           $stmt2-&gt;store_result();
          echo "true";
          echo $stmt2-&gt;num_rows;  // &lt;- this always return 0 even when its not
          $stmt2-&gt;close();
          $conn-&gt;commit();
      }
   else{
        $conn-&gt;rollback();
       echo "rollback";
    }
  
  }
  </code></pre>