MySQL update trigger for jos_rsform_submission_values table

Tables: a) jos_rsform_submission_values (this is RS Form Pro 1.4 table) b) cm_rsform_article_update (columns: id, form_id, submission_id, article_text, article_id) In the cm_rsform_article_update table: id: auto_increment column form_id: refers to FormId column in jos_rsform_submission_values submission_id: refers to SubmissionId column in jos_rsform_submission_values article_id: refers to id column in jos_content article_text: see sample value for this column below: Affiliations {affiliations:value} Achievements {achievements:value} On after UPDATE trigger on 'jos_rsform_submission_values' table: 1) replace values in {} brackets with relevant values in jos_rsform_submission_values 2) Update intro_text column in jos_content table for corresponding article_id's in cm_rsform_article_update table with value obtained in step 1 3) Repeat steps 1 and 2 for all rows in cm_rsform_article_update table The code should work for: 1. Joomla 1.5 2. MySQL 5.1 3. RS Form Pro 1.4