title: error in calling a mysql stored procedure from a php page
body: <p>Using phpmyadmin, i created a mysql stored procedure called <code>mySP()</code>. After creating the SP, i noticed that the SP is located in the information_schema db under ROUTINE table. I can see it here. Now from within phpmyadmin, under my actual database if i use SQL tab and do a call to the procedure using:
  CALL mySP();</p>
  
  <p>it works as required. NO issues.</p>
  
  <p>Now i am trying to extend this by having a php page call this SP.</p>
  
  <p>my php code is like this:</p>
  
  <pre><code>&lt;?php
  
  include("include_db_connection.php");
  
  
      $callSP_query = "CALL mySP()";
  
      $callSP_result =    mysqli_query($db_conn, $callSP_query) 
                              or die('Connected to database, but StoredProc failed');
  
          if(!$callSP_result)                 
          {
              echo "Error with StoredProc...";
          }
          else
          {
              echo "Succsess! Called Stored Proc..";
          }   
  
  ?&gt;
  </code></pre>
  
  <p>Now on loading this page on the browser, i always get the 'Connected to database, but StoredProc failed' error meaning that connection to db was established successfully, but there is some problem with calling the SP.</p>
  
  <p>what could be the problem? The SP was created successfully and even called successfully from within phpmyadmin. where is the php call going wrong?</p>
  
  <p>thanks!</p>
  
  <h3>EDIT:</h3>
  
  <p>I just checked the error code using mysqli_error() and it says "PROCEDURE mySP does not exist"</p>