On Monday 27 November 2006 07:59, Filipe Freitas wrote:
> Hi,
>
> This is not a mysql thing but maybe you can help me.
> I want to call a stored procedure from PHP, so I tried it like normal
> querys: mysql_query("CALL mySP();"); with no success.
>
> thx
No success how? Generally with stored procedures and returning values, you
use a session variable and utilize it as OUT like so:
DROP PROCEDURE IF EXISTS CURVAL $
CREATE PROCEDURE CURVAL (OUT current INT)
BEGIN
SELECT value INTO current FROM sequence;
END $
DELIMITER ;
so when I go to call curval:
CALL CURVAL(@cur)
and the value can be received by:
SELECT @cur;
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
