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