MySQL Stored Procedures - Need Help Getting Started...

My ultimate goal is to trigger a stored procedure when saving a record from a stand-alone entry form on a template. The stored procedure would basically take data that was just saved, compare it to other channels’/tables’ existing values and insert corresponding values into other blank fields inside the same record.

For example, my form asks you to choose 1, 2 or 3 (we’ll call this field_1 on my SAEF). If you choose ‘1’, then when you hit ‘Submit’, there would be some kind of trigger (like an empty field value or a pre-stored field value) that would launch a stored procedure in the database to query another table - using the ‘1’ entered by you - and insert the result into field_2 and re-save the record (if necessary).

So, based on the value you choose, another value is found and saved in another field in that same record…

Can someone get me started with some sort of example of a stored procedure in MySQL and maybe a trigger method? Something simple is fine, as long as I can grasp the concept of what is happening…

-Tony