//// HANDLE CHANGES if (isset($_REQUEST['process']) && $_REQUEST['process'] == 'true') { $logo = $_REQUEST['logo']; $country = $_POST['country']; $city = $_POST['city']; $state = $_POST['state']; $street = $_POST['street']; $phone = $_POST['phone']; $fax = $_POST['fax']; $web = $_POST['web']; $email = $_POST['email']; $datab = new MysqlManager(); $datab->connect(); $q = "SELECT * FROM `companyinfo`"; $res = $datab->query($q, true, " Error filling in additional detail fields: "); $num = $datab->getRowCount($result); if ($num = 0) { $query = 'INSERT into companyinfo (logo, country, city, state, street, phone, fax, web, email) VALUES'; $query .= "('{$logo}', '{$country}', '{$city}', '{$state}', '{$street}', '{$phone}', '{$fax}', '{$web}', '{$email}') "; $result = $datab->query($query, true, " Error filling in additional detail fields: "); } else { $query = "UPDATE companyinfo SET logo = '{$logo}' , \n country = '{$country}' , \n city = '{$city}', \n state = '{$state}', \n street = '{$street}', \n phone = '{$phone}', \n fax = '{$fax}', \n web = '{$web}', \n email = '{$email}'"; $result = $datab->query($query, true, " Error filling in additional detail fields: "); } $cfg->populateFromPost(); $cfg->handleOverride(); } /////////////////////////////////////////////////////////////////////////////// //// PAGE OUTPUT $sugar_smarty->assign('MOD', $mod_strings); $sugar_smarty->assign('APP', $app_strings);