Where and how do I excute MySQL stored procs?

[shanevdw]

How do I go about creating stored procedures in mySQL and how can I execute them in PHP? I'm using WAMP5. I want to create scripts but I don't really know where or how to execute them. Can someone please help.

Much appreciated

[NogDog]

Not an area of expertise for me, but this might get you started: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

[chazzy]

the best way to call the stored procedure is using mysqli, and specifically mysqli_stmt objects to represent the call to the SP and bind the parameters to it (both in and out).

[shanevdw]

Thanks will try it out. Much appreciated