stored procedure question

[csperler]

Hello,

Other than making use of the mysqli.so and pdo_mysql.so extensions, are there any other ways of (from php) calling mysql stored procedures and retrieving the result sets?

Thanks,

Craig

[MarkR]

You can actually call stored procedures with the mysql_ functions as well, provided:

1. You don't want to bind any parameters - which effectively prevents use of output parameters
2. You only return 1 result set from the procedure (as there's no way to retrieve more than one)

But in general, it works fine.

Mark

[csperler]

Hi Mark,

Thanks for the head's up. Even given the limitations you listed, I had been unable to call stored procedures with mysql; but after investigating a bit further [see http://bobfield.blogspot.com/2006/09/php-and-mysql-stored-procedures.html], I have gotten that functionality to work.

Thanks!

Craig