status update form EDIT functionality

[powpow]

Hello Freaks,

 

I am currently working on a status report web application.  A user inputs what they are planning on accomplishing that week.  Afterwords realizes that they made a mistake and need to correct it.  The way I want to go about this is sql the database and return * where the username and report date are current.

 

With the results of this query I insert them into the form as the value.  This yields a populated form.  From here I want the user to be able to change any line and submit the whole form.  However, the post array is only populated with one row of data.  I thought this might have to do with the names of the inputs all being the same so i tried to index those through the while loop with no luck.

 

Any help would be appreciated!

 

here's the code

 

 

<?
// renaming sess var
$UAID = $_SESSION['UAID'];
$WEND = $_SESSION['WEEK_ENDING2'];

//have we submitted our changes?
if($EDIT == TRUE){

//how many task are there this week
$results = mysql_query("Select COUNT(UAID) FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");
$row = mysql_fetch_row($results);

//clean $_POST 
print_r($_POST);
unset($_POST['Report']);
echo "<br>";
print_r($_POST);

}
//what do we plan on editing
$results = mysql_query("Select * FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");

//while there are results
while($row = mysql_fetch_array($results)){

//increment for input name
$k = 1;

//date formatting
list($year,$month,$day) = explode("-",$row['Target']);
$row['Target'] = $month."-".$day."-".$year;

//empty string to uncheck checkboxes
$checked = "";

//populate checkboxes
if($row['MS'] == "on"){
$checked = "yes";
}

//select the correct drop down menu option
if(isset($row['Status'])){
        if($row['Status'] == " "){
        $selected = "selected";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "P"){

        $selected = "";
        $selected1 = "selected";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "C"){

        $selected = "";
        $selected1 = "";
  	$selected2 = "selected";
        $selected3 = "";
        }

        elseif($row['Status'] == "CL"){

        $selected = "";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "selected";
        }
}

//select the correct drop down menu option
if(isset($row['OT'])){
        if($row['OT'] == "Y"){
        $selected4 = "selected";
        $selected5 = "";
        }

        elseif($row['OT'] == "N"){

        $selected4 = "";
        $selected5 = "selected";
        }
}

//var to send form to self
$cani = htmlentities($_SERVER['PHP_SELF']);

//concatenate html & php for form
$test =  "<form id =\"2bigform\" action=$cani method = \"post\">" . "<tr>" .
        "<td><input id=\"hidden\" name=\"UAID$k\" type=\"hidden\" value=" . $_SESSION['UAID'] ."></td>".
        "<td width=\"7%\"> <input id=\"SR\#$k\" name=\"SR#\" type=\"text\" size=\"10%\" maxlength=\"10\" value=" . $row['SRNUM'] . "></td>" .
        "<td width=\"63%\"> <input id=\"Task$k\" name=\"Task\" type=\"textarea\" size=\"63%\"  value=" . $row['Task'] . "></td>" .
        "<td width=\"7%\"> <select id=\"Status$k\" name=\"Status\">".
                                                        " <option value=\" \" $selected></option>".
                                                        " <option value=\"P\" $selected1>P</option>".
                                                        " <option value=\"C\" $selected2>C</option>".
                                                        " <option value=\"CL\" $selected3>CL</option>".
                                                        "</select></td>".

        "<td width=\"7%\"> <input id=\"MS$k\" name=\"MS\" type=\"checkbox\" size=\"7%\"  value=" . $row['MS'] . " checked = $checked></td>".
        "<td width=\"7%\"> <select id=\"OT$k\" name=\"OT\">".
                                                        " <option value=\"Y\" $selected4>Y</option>".
                                                        " <option value=\"N\" $selected5>N</option>".
                                                        "</select></td>".

     "<td width=\"9%\"> <input id=\"Target$k\" name=\"Target\" type=\"text\" size=\"9%\"  value=" . $row['Target'] . "></td>".
        "<input id=\"hidden\" name=\"RDate$k\" type=\"hidden\" value=" . $_SESSION['WEEK_ENDING'] ."></td></tr>";
echo $test;
$k++;
echo $k;
}
echo "</table>".
     "<input id=\"Sub\" type= \"Submit\" name=\"Report\" value= \"Submit\"/>".
     "</form>".
     "</body>".
     "</html>";

//<td width="7%"> <input id="SR#" name="SR#" type="text" size="10%" maxlength="10"/></td>
//<td width="63%"> <input id="Task" name="Task"  type="textarea" size= "63%"/></td>






}
?>

[Pikachu2000]

You have your <form> tag inside the while() loop. Only the last record returned from the database will be present in the $_POST array, most likely.