http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
with the help of above url i made procedure but failure to show result..
procedure
------------
CREATE PROCEDURE `testSelect`(IN tproductID INT(11), OUT tname VARCHAR(255))
BEGIN
SELECT name into tname from ss_products where productID = tproductID;
END
here is the script
*************
<?php
mysql_connect("localhost","root","root") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$result=mysqli_query("test_select(2)");
while ($row= mysql_fetch_array($result))
{
extract($row);
echo $row['name'];
}
if ($result==true)
{echo "pass";
}else { echo "fail";}
?>
result = fail
What is your Emotional Quotient? Find out here -
http://in.search.yahoo.com/search?&fr=na_onnetwork_mail_taglines&ei=UTF-8&rd=r1&p=emotional+quotient
[Non-text portions of this message have been removed]