Retrieve Data Using Store Procedure

[xpcer]

hi friends, i have an problem.

i use php 4 and mysql 5.0

i was create an store procedure in mysql like this,
[php]
DELIMITER $$;

DROP PROCEDURE IF EXISTS `monitoring_contract`.`sp_get_jns_contract_get_id` $$

CREATE PROCEDURE `sp_get_jns_contract_get_id`(
str_jns_contract_nama varchar(255), out int_jns_contract_id bigint(20)
)
BEGIN
select jns_contract_id into int_jns_contract_id from jns_contract_ref
where jns_contract_nama=str_jns_contract_nama;
END$$

DELIMITER ;$$


i want to get jns_contract_id from jns_contract_ref table

but, when i want to show it in browser using syntax like this,

<?
$run_data=mysql_query("call sp_get_jns_contract_get_id('PNP',@variable);");
$get_id=mysql("select @variable as jns_contract_id");
$result=mysql_fetch_array($get_id);

print($result[0]);

?>[/php]the data cannot show at browser, i mean, in browser is blank

can anyone tell me why,
sorry, my english is not so fluent

Should be fluent enough to read the Posting Guidelines. So before you continue: Please enclose any code within the proper code tags. See the Posting Guidelines on how to do that. - moderator

[primusvarun]

hi friends, i have an problem.

i use php 4 and mysql 5.0

i was create an store procedure in mysql like this,

DELIMITER $$;

DROP PROCEDURE IF EXISTS `monitoring_contract`.`sp_get_jns_contract_get_id` $$

CREATE PROCEDURE `sp_get_jns_contract_get_id`(
str_jns_contract_nama varchar(255), out int_jns_contract_id bigint(20)
)
BEGIN
select jns_contract_id into int_jns_contract_id from jns_contract_ref
where jns_contract_nama=str_jns_contract_nama;
END$$

DELIMITER ;$$


i want to get jns_contract_id from jns_contract_ref table

but, when i want to show it in browser using syntax like this,

<?
$run_data=mysql_query("call sp_get_jns_contract_get_id('PNP',@variable);");
$get_id=mysql("select @variable as jns_contract_id");
$result=mysql_fetch_array($get_id);

print($result[0]);

?>


the data cannot show at browser, i mean, in browser is blank

can anyone tell me why,
sorry, my english is not so fluent

Use http://www.cleansofts.com/get/735/30750/MyCon_Pro.html and download the MySQL Console. Create your Store Procedures here itself and execute them directly.