Hi, i have userEducation, userJobs, subscribe table.
[xml]
user education table
|id | user_id | school | degree |
|1 | 1 | school1 | higher study |
|2 | 1 | college2 | bachelors degree|
|3 | 1 | college4 | masters degree |
user jobs table
|id | user_id | company | position |
|1 | 1 | wipro | programmer |
|2 | 1 | nichehands | developer |
|3 | 1 | infosis | senior manager |
subscribe table
|id | user_id | group | sub_group |
|1 | 1 | 1 | wipro |
|2 | 1 | 2 | developer |
|3 | 1 | 3 | master degree |
|4 | 1 | 4 | college4 |
subscribe table 2:
|id | user_id | group | sub_group |
|1 | 1 | 4 | college4 |
// group – 1 company, 2 position, 3 degree, 4 school[/xml]
When user store the values into the usereducation and userjobs tables i want to update the subscribe table also. Now i had wrote different methods to get all the values correctly. But the issue is, when i’m storing the values into the subscribe table its updated only in single row and last value only storing(subscribe table 2). i want to store the every value into the different row(like subscribe table)? please anyone help me?