MySQL stored procedures from PHP code

I have a few PHP pages working as expected. But I want the SQL queries used in those pages to be converted to MySQL Stored procedures. This will allow me to manage the DB related business logic without learning PHP. Here is a simple test procedure that I will request all bidders to write and post. [login to view URL] If you want you can post only the first few lines of the SP. This will help me to understand the commitment and knowledge of the programmer. ## Deliverables * * *This broadcast message was sent to all bidders on Saturday Nov 7, 2009 6:26:46 AM: Hi, The bid submitted by the programmers who answer or suggest a way to write the correct SP for the problem mentioned on the following page will be considered. [login to view URL] -- Shantanu