} return false; } if (isset($_POST) && !empty($_POST)) { if ($GLOBALS['debug']) { echo "POSTS: "; var_dump($_POST); echo "<br />"; } $submission_is_US = 0; if (isset($_POST['us'])) { if ($_POST['us'] == 1) { $submission_is_US = 1; } } if (isset($_POST['name']) && !territoryExists($_POST['name'], $submission_is_US)) { //save the new territory $sqlSaveNewTerritory = "INSERT INTO territories (name"; if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) { $sqlSaveNewTerritory .= ", us"; } $sqlSaveNewTerritory .= ") VALUES('" . addslashes($_POST['name']) . "'"; if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) { $sqlSaveNewTerritory .= ", '" . $_POST['us'] . "'"; } $sqlSaveNewTerritory .= ")"; mysql_query($sqlSaveNewTerritory) or die('died trying to save new territory: ' . mysql_error()); $id = mysql_insert_id(); //save new regions for this territory if (isset($_POST['regions']) && !empty($_POST['regions'])) { //save this territories regional associations
$sqlTerritoryExists = "SELECT id FROM territories WHERE name LIKE '%".addslashes($name)."%'"; $resultTerritryExists = mysql_query($sqlTerritoryExists) or die('died checking if territory exists: '.mysql_error()); if (mysql_num_rows($resultTerritryExists) > 0) { return true; } return false; } if(isset($_POST) && !empty($_POST)) { if ($GLOBALS['debug']) { echo "POSTS: "; var_dump($_POST); echo "<br />"; } if (isset($_POST['name']) && !empty($_POST['name']) && !territoryExists($_POST['name'])) { //save the new territory $sqlSaveNewTerritory = "INSERT INTO territories (name"; if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) { $sqlSaveNewTerritory .= ", us"; } $sqlSaveNewTerritory .= ") VALUES('".addslashes($_POST['name'])."'"; if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) { $sqlSaveNewTerritory .= ", '".$_POST['us']."'"; } $sqlSaveNewTerritory .= ")"; mysql_query($sqlSaveNewTerritory) or die('died trying to save new territory: '.mysql_error());