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

Discussion in 'MySQL' started by progfrog, Dec 19, 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 19, 2008 IP