title: Mysqli prepared statement executing properly but no resultset
body: <p>In my <code>php</code> application using mysqli prepared statement to execute select query and it is executing properly but it not return any resultset. </p>
  
  <pre><code>public static function SelectByRegno($regno) {
      $foo = new Tapal_OutdwardDB();
      echo $regno;
      $myarray = array();
  
      $statement = $foo-&gt;mysqli-&gt;prepare("select type,subtype,regno,name,dept,despatchaddress,dealing,ddate,remarks from tapaldespatch where regno=? ");
      $statement-&gt;bind_param('S',$regno);
      $statement-&gt;execute();
      echo $statement-&gt;fullQuery; 
      $result = $statement-&gt;get_result();
      while($row=$result-&gt;fetch_array(MYSQLI_ASSOC)) {
          $myarray[] = $row;  
      } 
      return $myarray;
  }
  </code></pre>
  
  <p>The above code is worked in other application created by me. But, here i am facing problem, so please give me solution.</p>