Updating fields in a database

fforge 26 Sep, 2012
Hi,

I am using Chronoforms for a registration form, and saving the data to a new db i've set up using Chronoforms. This form includes a series of checkboxes where the user can select areas of interest.

I would like the user to be able to update their areas of interest by using another form with the same checkboxes in it, and when they submit, the fields in the db to be updated.

I am currently using the following configuration for the update form:
Events:
On Load:
Custom code(controller):
<?php
$user =& JFactory::getUser();
$form->data['user_id'] = $user->id;
?>

DB Record loader:
DB field - cf_uid
DB table - [the table i stored the registration data in]
Request param - cf_user_id (im really not sure about this part!)
Array field sets - subject1,subject2,subject3 etc (the names of the checkbox fields in the db)

Show HTML

Then on Submit I have a DB save to the same table

This doesn't work, but then im very unsure whether I have the correct configuration to update the db table! Is there anything obvious I'm doing wrong here?

Thanks
GreyHead 26 Sep, 2012
Hi fforge,

If you are adding the usaer id to $form->data['user_id'] then I think you need to use 'user_id' in the Request Param to match up.

Bob
This topic is locked and no more replies can be posted.