multiple update again :(

[mattotto77]

Hi all

here is a snippet of my code im having trouble generating the code to go through the fields submitted and update the fields where it matches on the database.

Any help would me appreciated

if($_POST["Vote"]) {
//pull voting info on company
$query = "Select * from RESOLUTIONS where MeetingId = '$MeetingId'";
$result = mysql_query($query) or die(mysql_error());

	$Choices = array (0=>"", "For", "Abstain", "Oppose", "Withdrawn", "No Resolution");

echo "<form name = \"frmSubmit\" action=\"$_SERVER[PHP_SELF]\" method=\"POST\"><input type=\"hidden\" name=\"MeetingId\" Value=\"$MeetingId\"><input type=\"submit\" name=\"Populate\" value=\"Populate with PIRC advice\"></form>";

echo "<form name = \"frmSubmit\" action=\"$_SERVER[PHP_SELF]\" method=\"POST\">";
echo"<table border=\"1\" width=\"695\">";

	$result = mysql_query($query);
	        while ($row = mysql_fetch_array($result)) {
   $i++;

echo "<tr><td class=\"red\">$row[ResId]<input type=\"hidden\" name=\"ResIdx\" Value=\"$row[ResIdx]\"></td><td class=\"red\">$row[Proposal]</td>";

print "<td><SELECT NAME=\"Vote$i\">\n";

		for ($ii=0;$ii<6;$ii++)
			{
		print "<OPTION NAME=\"$ii\"";
		if ($row["ChiswellVote"]==$Choices[$ii]) print " SELECTED";
		print ">";
		print "{$Choices[$ii]}";
		print "</OPTION>\n";

			}
		print "</SELECT></td></tr>";


echo "<tr><td></td><td><TextArea name= Analysis$i  cols = 70 rows = 3 wrap>$row[ChiswellAnalysis]</textarea></td></tr>";
}

echo "</table><input type=\"hidden\" name=\"test\" Value=\"test\"><input type=\"submit\" name=\"submit_advice\" value=\"Submit\"></form>";
}

if($_POST["submit_advice"]) {
echo "update changes";

$query="update RESOLUTIONS set Analysis='$Analysis$i', Vote='$Vote$i' where ResIdx='$ResIdx'";

}