Code: Select all
CREATE PROCEDURE pop_preregister(pre_regcode VARCHAR(8),
pre_link VARCHAR(40), pre_vreme INT(20))
BEGIN
INSERT INTO preregister VALUES (pre_regcode, pre_link, pre_vreme);
ENDCode: Select all
CALL pop_preregister('8w7q6i3M',
'd66dc262443f88d8f7e145142eed630544d5975f', 1195817114);But , if i try to do that from php script like:
Code: Select all
<?php
require_once ( "class.DbaseConnect.php" );
$regcode = "8w7q6i3M";
$link = "d66dc262443f88d8f7e145142eed630544d5975f";
$vreme = "1195817114";
$mysqli = dbaseConnect::db_connect();
$sql1 = "CALL pop_preregister($regcode, $link, $vreme)";
$result = $mysqli->query($sql1);
printf("%d Row inserted.\n<br />", $mysqli->affected_rows);
$mysqli->close();
?>MiSql version is 5.0.45.
It is probably some stypid mistake, but i can't see it.Thanks in advance.