PHP and Stored Procedures..!

[Bernini]

HI,

I've just upgraded my MySQL from 4.1 to version 5...i know its still in Alpha but its on a testing machine..nothing serious. Though i was looking into stored procedures..and they seem quite decent...what are your views on this? Also (most important to this thread), how does PHP runs a Stored procedure?

I mean usually i use mysql_query...bla bla but i haven't found anything on how to run the SPs! Any clue?


Thanks
B

 

[Olavxxx]

http://pear.php.net/package/DB

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[ingresman]

Stored procedures are very good, but be carefull. If you put too much logic into them the mysql engine becomes the execution environment and that is hard to scale across many servers and you loose a lot of the goof PHP things unless you partition your application well.