Connecting Tech Pros Worldwide Help | Site Map

sp's out parameter value

Newbie
 
Join Date: Feb 2008
Posts: 1
#1: Feb 28 '08
After the successfully connection with database
following is code
[php]$TM = mysql_query("Call Accounts_GetAllData(@data)");
$TM2 = mysql_query('SELECT @data');
$TM_X = mysql_fetch_array($TM);
$TM_W = mysql_fetch_array($TM2);
print_r(TM_W); [/php]I am not able to get out parameter(data). please response asap.

Thanks

You must enclose any code within the appropriate coding tags. See the Posting Guidelines before you continue - moderator
Newbie
 
Join Date: May 2007
Posts: 13
#2: Mar 17 '08

re: sp's out parameter value


The mysql API cannot fetch OUT parameter values. You'll need to use the improved API (mysqli) instead.

http://us3.php.net/manual/en/ref.mysqli.php

Also remove the @ from your variables, they are not necessary.
Reply