存储过程不适用于PHP调用[重复]

Question

Possible Duplicate:
Can't return a result set in the given context

I am trying to call a basic stored procedure using PHP. But mysql produces an error like "PROCEDURE softland.getAllProducts can't return a result set in the given context".

Stored Procedure

 DELIMITER //
 CREATE PROCEDURE GetAllProducts()
 BEGIN
 SELECT *  FROM products;
 END //
 DELIMITER ;

PHP code is

<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("softland",$con);
$id = 1;
$result = mysql_query("call getAllProducts()");
echo $result;

if ($result === FALSE) {
die(mysql_error());
}
while($row=mysql_fetch_array($result)){
    echo "<br>".$row['name'];
}
echo "Succees";
 ?>

Answer 1

Try this,

Function GetProducts($out)
{
    $query.= "CREATE PROCEDURE GetAllProducts() ";
    $query.= "BEGIN";
    $query.= "SELECT *  FROM products;";
    $query.= "END";
    return $query;
}

In the code put this,

$result = mysql_query(GetProducts());

Hope that works !!