title: SQL Query can not run after stored-procedure call in php
body: <p><strong>In My php code i call stored-procedure before Normal SQL (link : SELECT * FROM <code>TABLE</code>;) Query run. for that stored-procedure run but Normal SQL can-not run. I use mysql_query() in both case. but when i run normal SQL it run both time.</strong></p>
  
  <p>I have a class dataManager that have the mysql_query() </p>
  
  <p>here is my code :</p>
  
  <blockquote>
  <pre><code>require_once 'DL/DataManager.php'; 
  require_once 'utils/Utils.php';
  require_once 'DL/class/event/Event.php';
  </code></pre>
  </blockquote>
  
  <pre><code>$Utils = new Utils();
  $obj = new Event();
  
  $result = array();
  
  $result = $obj-&gt;get_all_event_data("NULL"); //Query =  "CALL events_all_data(" . $ID . ");";
  
  echo date("y-m-d h:i:s")."&lt;br /&gt;";
  
  echo $Utils-&gt;getString_UserName_ByUserID( "23" )."&lt;br /&gt;"; // Not Run   Query = SELECT  `USER_NICK` FROM  `USER_INFO` WHERE  `USER_ID` ='".$string ."';";
  </code></pre>
  
  <p><strong>DataManager.php</strong></p>
  
  <blockquote>
  <pre><code>public function openConnection()
  {
      $this-&gt;connection = mysql_connect($this-&gt;HostName, $this-&gt;UserName, $this-&gt;PassWord);
          if (!$this-&gt;connection)
          {
                  return mysql_error();
          }
          mysql_select_db($this-&gt;DataBase);
          return $this-&gt;connection;
  } 
  </code></pre>
  </blockquote>
  
  <p><strong>execute sql query</strong> </p>
  
  <pre><code>public function retrieveData($Query = "")
  {
      //$Query = mysql_real_escape_string($Query);
      //echo "DB retriveData query : ".$Query. " &lt;br /&gt;";
      $data = mysql_query($Query);
      $num_rows = mysql_num_rows($data);
      //echo "db ret number : ".$num_rows." asdas: ". "\n";
  
  
      if($num_rows)
      {
          $this-&gt;Data = array();
          //$i = 0;
          while ($mat[] = mysql_fetch_row($data));
              //echo $mat[$i++][2]."&lt;br /&gt;";
          $this-&gt;Data = $mat;
          //print_r($this-&gt;Data);
      //$result = $this-&gt;getArrayTranspose($mat);
      }
      else
      {
          $this-&gt;Data = NULL;
      }
  
      //return $result;
  
  }
  </code></pre>
  
  <p><strong>Connection Close</strong></p>
  
  <pre><code>public function closeConnection()
  {
      if(!$this-&gt;connection)
      {
          mysql_close ();
  
          return ;
      }
      else if($this-&gt;connection == NULL)
      {
          mysql_close ();
  
          return ;
      }
      else if(!isset($this-&gt;connection))
      {
          mysql_close ();
  
          return ;
      }
      else if(is_resource($this-&gt;connection))
      {
          mysql_close($this-&gt;connection);
          return ;
      }
      else
      {
          //mysql_close();
      }
  
  }
  </code></pre>