// Delete any current data elements in THIS table since I only want to store the values
// from this submit in another form.
$database->setQuery("DELETE FROM jos_forme_data WHERE form_id=5" );
$database->query(); 
 
 
// Only process when my field of interest is set and the submit button was pressed.
if(isset($_POST['form']['specialName'])) {
$specialNameValue=$_POST['form']['specialName'];
 
 
 
// Setup database access to existing table that I will store the field from this submit in.
$database->setQuery("SELECT id as mykey, form_id as formid, params as formData FROM jos_forme_data WHERE form_id =4" );
$allFormEntries = $database->loadObjectList();
 
 
// loop through all table entries in the table I want to store the value from this submit
// 
// Loop Post Condition:
//   All fields in target table will be set to the one field from this submit.
foreach($allFormEntries as $anEntry){
 
  // use a regular expression search and replace
  // We will look for the fieldname and its value and replace
  // the value with the one from this form.
$newFormData=preg_replace ("/special=.*\|\|/", "special=$specialNameValue||",$anEntry->formData);
 
  // Now we will replace the old form data in the database table
  // with the new form data.
  //  This updates the special name with the new name for all
  //  restaurants.
  $database->setQuery("UPDATE jos_forme_data SET params='$newFormData' WHERE id=$anEntry->mykey ");
 
  $database->query(); 
}
 
 
} // check for submission