I have a page where users can enter a beneficiary name through a dropdown box and a textbox where a description can be entered(beneficiary type) for a project. Currently it writes one of each beneficiary name to the beneficiary table. the fields in the table are project id, beneficiary name and beneficiary type.
My clients want to be able to enter 2 of the same beneficiary names but i am unable to get this to write to the table.
Here is the code:
function ben_exists($project,$ben){
$exists_query = "Select count(*) as Number from beneficiary where ProjectID = '$project' and BeneficiaryName = '$ben'";
$exists_result = mysql_query($exists_query);
$result_array = mysql_fetch_assoc($exists_result);
return $result_array['Number'];
}
if ($_POST['SaveBeneficiaries'])
{
$Today = date("Y-m-d",time());
$update_query = "Update projects set LastUpdatedDate='$Today' where ProjectID = '$ID'";
$update_project_result = mysql_query($update_query,$connection) or die(mysql_error());
$ben1 = $_POST['select1'];
$ben2 = $_POST['select2'];
$ben3 = $_POST['select3'];
$ben4 = $_POST['select4'];
$ben5 = $_POST['select5'];
$ben6 = $_POST['select6'];
$ben7 = $_POST['select7'];
$ben8 = $_POST['select8'];
$ben9 = $_POST['select9'];
$ben10 = $_POST['select10'];
$type1 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield1']))));
$type2 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield2']))));
$type3 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield3']))));
$type4 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield4']))));
$type5 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield5']))));
$type6 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield6']))));
$type7 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield7']))));
$type8 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield8']))));
$type9 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield9']))));
$type10 = addslashes(str_replace("\'", "''", htmlspecialchars(trim($_POST['textfield10']))));
$delete_query = "Delete from beneficiary where ProjectID = '$ID'";
$delete_result = mysql_query($delete_query,$connection) or die(mysql_error());
if (strlen($ben1) != 0 and ben_exists($ID,$ben1)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben1','$type1')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben2) != 0 and ben_exists($ID,$ben2)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben2','$type2')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben3) != 0 and ben_exists($ID,$ben3)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben3','$type3')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben4) != 0 and ben_exists($ID,$ben4)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben4','$type4')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben5) != 0 and ben_exists($ID,$ben5)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben5','$type5')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben6) != 0 and ben_exists($ID,$ben6)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben6','$type6')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben7) != 0 and ben_exists($ID,$ben7)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben7','$type7')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben8) != 0 and ben_exists($ID,$ben8)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben8','$type8')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben9) != 0 and ben_exists($ID,$ben9)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben9','$type9')";
mysql_query($insert_query,$connection) or die(mysql_error());}
if (strlen($ben10) != 0 and ben_exists($ID,$ben10)==0)
{$insert_query = "Insert into beneficiary(ProjectID,BeneficiaryName,BeneficiaryType) values ('$ID','$ben10','$type10')";
mysql_query($insert_query,$connection) or die(mysql_error());}
$confirmation_message = "Project beneficiaries recorded";
}
else
{
$query_beneficiaries = "Select ProjectID,BeneficiaryName,BeneficiaryType from beneficiary where ProjectID='$ID'";
$beneficiaries = mysql_query($query_beneficiaries,$connection) or die(mysql_error());
$num_bens = mysql_num_rows($beneficiaries);
if ($num_bens >= 1)
{
$row_ben1 = mysql_fetch_assoc($beneficiaries);
$ben1 = $row_ben1['BeneficiaryName'];
$type1 = $row_ben1['BeneficiaryType'];
}
if ($num_bens >= 2)
{
$row_ben2 = mysql_fetch_assoc($beneficiaries);
$ben2 = $row_ben2['BeneficiaryName'];
$type2 = $row_ben2['BeneficiaryType'];
}
if ($num_bens >= 3)
{
$row_ben3 = mysql_fetch_assoc($beneficiaries);
$ben3 = $row_ben3['BeneficiaryName'];
$type3 = $row_ben3['BeneficiaryType'];
}
if ($num_bens >= 4)
{
$row_ben4 = mysql_fetch_assoc($beneficiaries);
$ben4 = $row_ben4['BeneficiaryName'];
$type4 = $row_ben4['BeneficiaryType'];
}
if ($num_bens >= 5)
{
$row_ben5 = mysql_fetch_assoc($beneficiaries);
$ben5 = $row_ben5['BeneficiaryName'];
$type5 = $row_ben5['BeneficiaryType'];
}
if ($num_bens >= 6)
{
$row_ben6 = mysql_fetch_assoc($beneficiaries);
$ben6 = $row_ben6['BeneficiaryName'];
$type6 = $row_ben6['BeneficiaryType'];
}
if ($num_bens >= 7)
{
$row_ben7 = mysql_fetch_assoc($beneficiaries);
$ben7 = $row_ben7['BeneficiaryName'];
$type7 = $row_ben7['BeneficiaryType'];
}
if ($num_bens >= 8)
{
$row_ben8 = mysql_fetch_assoc($beneficiaries);
$ben8 = $row_ben8['BeneficiaryName'];
$type8 = $row_ben8['BeneficiaryType'];
}
if ($num_bens >= 9)
{
$row_ben9 = mysql_fetch_assoc($beneficiaries);
$ben9 = $row_ben9['BeneficiaryName'];
$type9 = $row_ben9['BeneficiaryType'];
}
if ($num_bens >= 10)
{
$row_ben10 = mysql_fetch_assoc($beneficiaries);
$ben10 = $row_ben10['BeneficiaryName'];
$type10 = $row_ben10['BeneficiaryType'];
}
}
?>
