Re: [PHP-DB] Procedure Parameter OUT values

WebPat wrote:
> Chris wrote:
>> WebPat wrote:
>>> I am surprised by the order of the data returned from my stored 
>>> procedure, and that it appears associated with the incorrect variables.
>>> Apparently the data is returned entirely positionally, without 
>>> consideration for the variable names. So, the names of the OUT 
>>> parameters in the procedure appear to be invisible outside of the 
>>> procedure. Although I pass in variables with the same names as the 
>>> Parameters, they are filled positionally - in the "wrong" variables - 
>>> because in this case I had two variables reversed positionally.
>>> When I retrieve them using fetch_assoc, the wrong data appears in the 
>>> result.
>>
>> I'd probably find a more targeted mailing list (a specialized one for 
>> your database - whatever it is) and see if they can offer any 
>> suggestions.
>>
> 
> My database is Mysql. The data seems to display properly there. I'm 
> accessing the database with procedures that are part of PHP and that is 
> where I believe the problem is. That's why I asked it on this "Newsgroup".
> 
> I got it to work by putting my parameters in the proper order. I know 
> this is how function and procedure calls normally work, but the 
> documentation of fetch_assoc() leads in another direction. It looks like 
> the "Associations" are created within my php and not carried from the 
> database for stored procedures. I wonder if PHP does this for all 
> databases? I think this differs from "Select * From Table". Certainly 
> could use another sentence in the documentation.

You can submit documentation patches and/or submit a note for that 
situation on that page in the manual.

-- 
Postgresql & php tutorials
http://www.designmagick.com/