setQuery("Insert into " . TABLE_DOMAINS_PRICE . " values('','{$_POST['tld0']}','{$_POST['price0']}')");
$database->query();
$url = tep_href_link(FILENAME_DOMAINS, 'msg=' . TEXT_UPDATE_COMPLETE);
tep_redirect($url);
break;
case "update":
//step 1 remove the deleted options
if(isset($_POST['dom'])){
foreach($_POST['dom'] as $key => $value){
$database->setQuery("Delete from " . TABLE_DOMAINS_PRICE . " where tld_id = '$key'");
$database->query();
}
}
//step 2-> update all prices
foreach($_POST['price'] as $key => $value){
$database->setQuery("update " . TABLE_DOMAINS_PRICE . " set price = '$value' where tld_id = '$key'");
$database->query();
}
//show the page again
$url = tep_href_link(FILENAME_DOMAINS, 'msg=' . TEXT_UPDATE_COMPLETE);
tep_redirect($url);
break;
case "add":
?>