Forums

Hi,

I need to get max cf_id from the first table and change from cf_id to schoolid, then insert the newest schoolid to the second table.

What I did was,
1. I have DB save, save the form data to the first table
2. Create a custom code to get max cf_id and assign max cf_id to schoolid
3. Have a DB save, save the form data to the second table with the newest schoolid

I do not know what did I do wrong, every time, the second DB save always save 127 instead of the max id that I just grab. I have debugger, and I see [chronoforms_data] => array ([Schoolid] =>249. When it inserts, it inserts 127.

My first DB Save
Table = xxxxx_chronoforms_data_school_lookup
Model ID = chronoform_data
Save under Model ID = No
----------------
My custom code
<?php

$db =& JFactory::getDBO();

$db->setQuery('select max(cf_id) from xxxxx_chronoforms_data_school_lookup order by cf_id desc limit 1');

$result = $db->loadResult();

// turn max id to schoolid
$form->data['chronoform_data']['Schoolid'] = $result;

// assign new schoolid to school id in internship table
$form->data['Schoolid'] = $form->data['chronoform_data']['Schoolid'] ;
?>
---------------
My second DB Save
Table = xxxxx_chronoforms_data_internship
Model ID = blank, no Model ID
Save under Model ID = No

Please advise,

Thank you,

Nilubon