MySQL update trigger for jos_rsform_submission_values table


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:





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

Taidot: Joomla, MySQL, PHP

Näytä lisää: mysql 5.1, php brackets, mysql update values, update values mysql, update php joomla, mysql tables rows, joomla table mysql, brackets php, joomla form step step, update table trigger update table mysql, php mysql update table joomla, mysql update table, joomla php update table, form update php mysql joomla, step step form joomla, joomla trigger, php mysql trigger, mysql replace values, value table, replace values mysql, joomla step form, mysql replace, brackets joomla, joomla mysql php, joomla mysql trigger

Tietoa työnantajasta:
( 160 arvostelua ) Cairo, Egypt

Projektin tunnus: #4264656

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


ready to start Thanks

$70 USD 4 päivässä
(149 arvostelua)

Dear friend Please check your PMB to see more detail. Thank you

$100 USD 5 päivässä
(92 arvostelua)

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have understood and able to visualize what you are looking for, I can do this job quickly with quality.

$100 USD 2 päivässä
(38 arvostelua)

Hello, I can do it quickly for you. Please check your private message for more detail. Thank you

$80 USD 1 päivässä
(6 arvostelua)

Hi D&D, I can do it, and ready to start.

$100 USD 2 päivässä
(2 arvostelua)