using a script to start a stored procedure and assigning a variable

Discussion in 'PHP' started by progfrog, Dec 17, 2008.

0
  1. #1
    hello, i've created a stored procedure that looks like so:

    
DELIMITER $$

DROP PROCEDURE IF EXISTS `yoyo`.`ShowNames` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ShowNames`(IN Bname varchar(10) )
BEGIN
INSERT INTO jeta (BookNname)
VALUES (Bname);
END $$

DELIMITER ;
    Code (markup):
    and a php script to trigger it that looks like so:
    
<?php
$mysql_link= mysql_connect('localhost','root','********') or die("ERROR:cannot 

connect");
echo "connected successfully to MySQL server.";

mysql_select_db('yoyo',$mysql_link) or die ("could not open db".mysql_error());
echo "connected successfully.";

$sql = "CALL ShowNames('daniel')";
echo"SP used";
mysql_close($mysql_link);
?>
    PHP:

    but when i start the script i do not see any change in my "jeta" table, which makes me kind of doleful. so do oblige my fellow developers. 10x.
     
    progfrog, Dec 17, 2008 IP