2 replies to this topic

[dadli]

hello
i need create stored procedures (in mysql), but This is what happens: if i trying create procedure using php file, output is error:

Quote

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 'DELIMITER // CREATE PROCEDURE `procpros`(OUT ppp VARCHAR(70)) NOT DETERMIN' at line 1

this is my php file:

include 'dbconnect.php';

mysqli_query($db,

"DELIMITER //

CREATE PROCEDURE `procpros`(OUT ppp VARCHAR(70))

   NOT DETERMINISTIC

   SQL SECURITY INVOKER

   COMMENT ''

BEGIN

SELECT shemos_dro INTO ppp FROM online WHERE ipadres = 55 LIMIT 1;

END;//

DELIMITER ;

")or die(mysqli_error($db));

but if, i trying create procedure using phpmyadmin (if I run this sql query in phpmyadmin) all its good, procedure is creating successfully, tell me please why this happened? create procedure using the php file can not ? Thanks

[Orjan]

The problem is that mysqli_query only allows one command to the server at a time, you make three. Two delimiter and one create procedure

[dadli]

Orjan, thanks very much :)