[prev in list] [next in list] [prev in thread] [next in thread]
List: php-general
Subject: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)
From: Ian Porter <ian () designersoft ! co ! uk>
Date: 2005-02-07 20:55:39
Message-ID: 200502072055.39821.ian () designersoft ! co ! uk
[Download RAW message or body]
Hi,
I am just wondering how to obtain the result from a mysql procedure OUT
parameter within PHP e.g.
MYSQL
create procedure test_out(OUT testvar int)
BEGIN
select max_connections into testvar from mysql.user limit 1;
END
PHP
$query = 'call test_out('.$test_val.')';
$query_handle = mysql_query($query);
but there is nothing within the $test.val, after searching the web there
appears to be something like this for oracle connection with the bind, but I
cannot find the mysql version ?
Any advice ?
Cheers
Ian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic