GuardianOfTheFlame
Programmer
Hi all,
I'm using a MySQL database that contains some stored procedures. Some of them have output parameters.
How can I call those sproc?
I've tried using mysqli, but I cannot understand how to call a procedure that execute a SELECT statement and use 2 output parameters. :-|
i.e. how can I execute this in PHP:
call sp_GetUsers('ProjectName',@ErrorNumber, @ErrorMessage)
(it returns a list of users and 2 output parameters used for logical error such as 'Invalid Project Name')
I hope someone can help me ':-|
Thanks!
Salo
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)
I'm using a MySQL database that contains some stored procedures. Some of them have output parameters.
How can I call those sproc?
I've tried using mysqli, but I cannot understand how to call a procedure that execute a SELECT statement and use 2 output parameters. :-|
i.e. how can I execute this in PHP:
call sp_GetUsers('ProjectName',@ErrorNumber, @ErrorMessage)
(it returns a list of users and 2 output parameters used for logical error such as 'Invalid Project Name')
I hope someone can help me ':-|
Thanks!
Salo
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)