title: Calling Simple Procedure in PHP which Outputs Variable
body: <p>I am Trying to call a Simple Procedure which returns name to PHP Page.</p>
  
  <p>I am Getting empty record set while doing this</p>
  
  <p><strong>Procedure</strong></p>
  
  <pre><code>DROP PROCEDURE IF EXISTS prSample1;
  CREATE PROCEDURE prSample1(OUT Name VARCHAR(255))
  BEGIN
   SET Name = 'Mugil';
   SELECT Name;
  END;
  </code></pre>
  
  <p><strong>PHP Procedure Call</strong></p>
  
  <pre><code>    mysql_connect('localhost', 'root', '');
      mysql_select_db('dbName');
  
      $strSQL = "CALL prSample1(@Name);";
      $Result = mysql_query($strSQL);
  
      $strSQL = "SELECT @Name";
      $Result = mysql_query($strSQL);
  
      while($Row = mysql_fetch_array($Result))
        $Name = $Row[0];
  
      print $Name;
  </code></pre>
  
  <p>I am not getting the Name when i run This PHP Code. </p>
  
  <p>Thank you fro your reply </p>