DROP PROCEDURE return error
Date: October 15, 2009 01:06PM
<?php
$con = mysql_connect('localhost','root','**********');
mysql_select_db('******');
$query = "
DROP PROCEDURE IF EXISTS func;
CREATE PROCEDURE func (OUT ver INT)
BEGIN
SELECT 5 INTO ver;
END
CALL func(@a);
SELECT @a;
DROP PROCEDURE func;";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
mysql_close($con);
?>
When I run the script I get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE PROCEDURE func (OUT ver INT) BEGIN SELECT 5 INTO ver; END CAL' at line 1
help please :D