title: mysqli,php store procedure not executing : getting Error
body: <pre><code>$link = mysqli_connect("localhost",
  "username", "testpassword",
  "dbname")or die('connection
  problem');
  
  /* check connection */ if
  (mysqli_connect_errno()) {   
  printf("Connect failed: %s\n",
  mysqli_connect_error());    exit(); }
  
  //if ($result = mysqli_query($link,
  "CALL my_sqrt(Other,@out_value)")) {
  
  $result = mysqli_query($link, "CALL  show_sp_test()");
  
  $row_cnt = mysqli_num_rows($result);
  
  printf("Result set has %d rows.\n",
  $row_cnt);
  
  /* close result set */   
  mysqli_free_result($result); //}
  
  /* close connection */
  mysqli_close($link);
  </code></pre>
  
  <p>I got error like </p>
  
  <blockquote>
    <p>Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result,
    boolean given in sample-sp.php on line 19
        Result set has 0 rows.
        Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in sample-sp.php on line 24</p>
  </blockquote>
  
  <p>but i change the stored procedure CALL to normal query working fine, </p>
  
  <p>Tell me , is there any thing i should check /, </p>
  
  <p>Is there any Bug in my snippet,</p>
  
  <p>NOTE: IN MY SERVER MYSQLI ENABLED</p>
  
  <p>Thanks</p>