For some reason the code below only returns the last variable checked...
$array = array();
for ($i=0; $i<=2;$i++){
$name = array();
$address = array();
$relationship = array();
$name[$i]=$_POST['name'.$i];
$address[$i]=$_POST['address'.$i];
$relationship[$i]=$_POST['relationship'.$i];
if ($i==0) {
$name[$i]=$verify->check_field($_POST['name'.$i], "Please enter a name for estate manager #".($i+1)."", true);
$address[$i]=$verify->check_field($_POST['address'.$i], "Please enter an address for estate manager #".($i+1)."", true);
$relationship[$i]=$verify->check_field($_POST['relationship'.$i], "Please enter the relationship for estate manager #".($i+1)."", true);
}
else {
if (!empty($name[$i]) || !empty($address[$i]) || !empty($relationship[$i])) {
$name[$i]=$verify->check_field($_POST['name'.$i], "Please enter a name for estate manager #".($i+1)."", true);
$address[$i]=$verify->check_field($_POST['address'.$i], "Please enter an address for estate manager #".($i+1)."", true);
$relationship[$i]=$verify->check_field($_POST['relationship'.$i], "Please enter the relationship for estate manager #".($i+1)."", true);
}
}
if (($name[$i]=='') && ($address[$i]=='') && ($relationship[$i]=='')) {
continue;
}
else{
if(!$verify->errors) {
$query = "SELECT * FROM u_est_manage WHERE`user_id`='".$_SESSION['uid']."'";
$result = $db->query($query);
if($db->num_rows($result) > 0) {
$array[$i]="UPDATE u_est_manage SET `name`='".$name[$i]."',`address`='".$address[$i]."',`relationship`='".$relationship[$i]."') WHERE `user_id`='".$_SESSION['uid']."' AND `id`='".$i."'";
}
else {
$array[$i]="INSERT INTO u_est_manage (user_id,id,name,address,relationship) VALUES ('".$_SESSION['user_id']."','".$i."','".$name[$i]."','".$address[$i]."','".$relationship[$i]."')";
}
}
}
}
It is called later through some html which just echos the $name[0] etc variables...any thoughts?