honestly, I a m not familiar enough with using stored procedures in php to be able to give a code example.
I dod a search on google for:
php mysql stored procedures tutorial
and this is the first result:
http://www.sitepoint.com/stored-procedures-mysql-php/
it looks like that should be helpful.