Submit button not working correctly

[richcoosa19]

I am designing a database driven website. I am using dynamic drop down menus and giving each record a update button, however when you click the button it only submits the last one in the list. The button is not taking the values on the row it was made. Here is the code:

	<table border="1"> 
  <tr> 
    <td>Assign to this Agent<br><select name="username" size="1"> 
    <option value="new" selected>--Select One--</option>
	 <?php	do {  ?>

<option value="<?php echo $row_LOC22['username']?>"><?php echo $row_LOC22['l_name']?>, <?php echo $row_LOC22['f_name']?></option>
<?php } while ($row_LOC22 = mysql_fetch_assoc($result2)); ?>
</select></td>
<td>Amount</td>
<td>Business_Name</td>
<td>dba</td>
<td>Street</td>
<td>Business_City</td>
<td>Business_State</td>
<td>Business_Zip</td>
<td>Contact</td>
<td>Phone</td>
<td>Moblie_Phone</td>
<td>Fax</td>
<td>Email</td>
<td>Years_in_Business</td>
<td>TaxID</td>
<td>D_and_B</td>
<td>Type_of_Ownership</td>
<td>Twelve_Month_Gross</td>
<td>TaxID1</td>
<td>Visa_Master_Sales</td>
<td>Equipment_Location</td>
<td>Average_Bank_Balance</td>
<td>Bank</td>
<td>Bank_Phone</td>
<td>Bank_Account_Number</td>
<td>Bank_Contact</td>
<td>First_Name_Principal</td>
<td>Last_Name</td>
<td>Home_Phone</td>
<td>Title</td>
<td>Percent_Ownership</td>
<td>SSN</td>
<td>DOB</td>
<td>Home_Street</td>
<td>City</td>
<td>State</td>
<td>Zip</td>
<td>Personal_Net_Worth</td>
<td>Annual_Household_Income</td>
<td>Monthly_Mortgage_Payment</td>
<td>Ref1_Company_Name</td>
<td>Ref1_Company_Name1</td>
<td>Ref1_Phone</td>
<td>Ref1_Company_Account</td>
<td>Ref1_Contact_Name</td>
<td>Ref2_Phone</td>
<td>Ref2_Company_Account</td>
<td>Ref2_Contact_Name</td>
<td>Ref3_Company_Name</td>
<td>Ref3_Phone</td>
<td>Ref3_Company_Account</td>
<td>Ref3_Contact_Name</td>
<td>Borrowers_Comments</td>
<td>B1</td>
<td>Referer</td>
<td>Remote_Name</td>
<td>Date</td>
<td>Time</td>
<td>Comments</td>
</tr>
<?php if($totalRows > 0) do { ?>
<tr>
<td>
<input name="Business_Name" type="hidden" value="<?php echo $row_LOC2['Business_Name'] ?>">
<input name="Amount" type="hidden" value="<?php echo $row_LOC2['Amount'] ?>">
<input name="submit" type="submit" value="Assign Agent">
</td>
<td><?php echo $row_LOC2 ['Amount']; ?></td>
<td><?php echo $row_LOC2 ['Business_Name']; ?></td>
<td><?php echo $row_LOC2 ['dba']; ?></td>
<td><?php echo $row_LOC2 ['Street']; ?></td>
<td><?php echo $row_LOC2 ['Business_City']; ?></td>
<td><?php echo $row_LOC2 ['Business_State']; ?></td>
<td><?php echo $row_LOC2 ['Business_Zip']; ?></td>
<td><?php echo $row_LOC2 ['Contact']; ?></td>
<td><?php echo $row_LOC2 ['Phone']; ?></td>
<td><?php echo $row_LOC2 ['Moblie_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Fax']; ?></td>
<td><?php echo $row_LOC2 ['Email']; ?></td>
<td><?php echo $row_LOC2 ['Years_in_Business']; ?></td>
<td><?php echo $row_LOC2 ['TaxID']; ?></td>
<td><?php echo $row_LOC2 ['D_and_B']; ?></td>
<td><?php echo $row_LOC2 ['Type_of_Ownership']; ?></td>
<td><?php echo $row_LOC2 ['Twelve_Month_Gross']; ?></td>
<td><?php echo $row_LOC2 ['TaxID1']; ?></td>
<td><?php echo $row_LOC2 ['Visa_Master_Sales']; ?></td>
<td><?php echo $row_LOC2 ['Equipment_Location']; ?></td>
<td><?php echo $row_LOC2 ['Average_Bank_Balance']; ?></td>
<td><?php echo $row_LOC2 ['Bank']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Account_Number']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Contact']; ?></td>
<td><?php echo $row_LOC2 ['First_Name_Principal']; ?></td>
<td><?php echo $row_LOC2 ['Last_Name']; ?></td>
<td><?php echo $row_LOC2 ['Home_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Title']; ?></td>
<td><?php echo $row_LOC2 ['Percent_Ownership']; ?></td>
<td><?php echo $row_LOC2 ['SSN']; ?></td>
<td><?php echo $row_LOC2 ['DOB']; ?></td>
<td><?php echo $row_LOC2 ['Home_Street']; ?></td>
<td><?php echo $row_LOC2 ['City']; ?></td>
<td><?php echo $row_LOC2 ['State']; ?></td>
<td><?php echo $row_LOC2 ['Zip']; ?></td>
<td><?php echo $row_LOC2 ['Personal_Net_Worth']; ?></td>
<td><?php echo $row_LOC2 ['Annual_Household_Income']; ?></td>
<td><?php echo $row_LOC2 ['Monthly_Mortgage_Payment']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Name1']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Company_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Borrowers_Comments']; ?></td>
<td><?php echo $row_LOC2 ['B1']; ?></td>
<td><?php echo $row_LOC2 ['Referer']; ?></td>
<td><?php echo $row_LOC2 ['Remote_Name']; ?></td>
<td><?php echo $row_LOC2 ['Date']; ?></td>
<td><?php echo $row_LOC2 ['Time']; ?></td>
</tr>
<?php } while ($row_LOC2 = mysql_fetch_assoc($result));?>
</table></form>

Sorry I know this is a lot of code, but I'm getting desperate here.

[bastien]

try showing the page with the insert code in it...the page with the form is really not much use...what fields are to be updated?

[richcoosa19]

The field to be updated is the agent. The id's are Business_Name and Amount. Using these two fields the system determines which record to update. The problem is that no matter which record you descide to update the agent, it updates the last record.

[bastien]

assuming that business_name and amout are being set correctly and coming correctly from the form, the only place the error can be is the page that update the database....

show that code

[richcoosa19]

This is not so, because I have echoed the values in the page that does the updating and the record to be updated never changes. Well the agent to be assigned does, but the wrong record is given to the update page than was selected. Basically this submit button is not following the record list as loop is executed.

[bastien]

are business_name and amout are being set correctly in the form?

yes or no?

[richcoosa19]

No that is the problem they are only getting the last value in the loop of records. No matter which button I select to change agent to, only the last one will be selected.

[bastien]

so show the entire code for that page and any code where imported varaibles are set

[richcoosa19]

Code, and a lot of it!
So you know with the connections I took out the login and password aswell as the database names.

<?php
$username = $POST[name];
$where = "agent='new'";
?>
<?php
$user="";
$host="localhost";
$password="";
$database="";
mysql_connect($host,$user,$password);
mysql_select_db($database);
$columns="";
$table="";
$query="SELECT $columns FROM $table WHERE $where";
$result = mysql_query($query);
$row_LOC2 = mysql_fetch_array($result);
$totalRows = mysql_num_rows($result);
?>
<?php
$agent_where="authorization='Agent'";
$user2="";
$host2="localhost";
$password2="";
$database2="";
mysql_connect($host2,$user2,$password2);
mysql_select_db($database2);
$columns2="";
$table2="";
$query2="SELECT $columns2 FROM $table2 WHERE $agent_where";
$result2 = mysql_query($query2);
$row_LOC22 = mysql_fetch_array($result2);
$totalRows2= mysql_num_rows($result2);
?>
<?php
echo $POST[username];
$firstnamewhere="username='$username'";
$user2="";
$host2="localhost";
$password2="";
$database2="";
mysql_connect($host2,$user2,$password2);
mysql_select_db($database2);
$columns2="";
$table2="*";
$firstnamequery="SELECT $columns2 FROM $table2 WHERE $firstnamewhere";
$firstnameresult = mysql_query($firstnamequery);
$firstnamearray = mysql_fetch_array($firstnameresult);
$firstname=$firstnamearray[f_name];
if(!$firstname){$firstname=$_GET[firstname];}
?>

<html>
<head>
<title>Database Managment Assigner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<h3>
<div align="center">
<p>Good day, <?php do { echo $firstname; } while($first = mysql_fetch_assoc($firstnameresult));?>! <?php echo("<h1>It works!</h1>"); echo $firstname;?></p>
<p>You presently have <?php echo $totalRows?> assigned flag(s).</p>
<a href="index.php">Back to Login Page</a>
<form name="username" method="post" action="givetoagent.php">
<table border="1">
<tr>
<td>Assign to this Agent<br><select name="username" size="1">
<option value="new" selected>--Select One--</option>
<?php do { ?>
<option value="<?php echo $row_LOC22['username']?>"><?php echo $row_LOC22['l_name']?>, <?php echo $row_LOC22['f_name']?></option>
<?php } while ($row_LOC22 = mysql_fetch_assoc($result2)); ?>
</select></td>
<td>Amount</td>
<td>Business_Name</td>
<td>dba</td>
<td>Street</td>
<td>Business_City</td>
<td>Business_State</td>
<td>Business_Zip</td>
<td>Contact</td>
<td>Phone</td>
<td>Moblie_Phone</td>
<td>Fax</td>
<td>Email</td>
<td>Years_in_Business</td>
<td>TaxID</td>
<td>D_and_B</td>
<td>Type_of_Ownership</td>
<td>Twelve_Month_Gross</td>
<td>TaxID1</td>
<td>Visa_Master_Sales</td>
<td>Equipment_Location</td>
<td>Average_Bank_Balance</td>
<td>Bank</td>
<td>Bank_Phone</td>
<td>Bank_Account_Number</td>
<td>Bank_Contact</td>
<td>First_Name_Principal</td>
<td>Last_Name</td>
<td>Home_Phone</td>
<td>Title</td>
<td>Percent_Ownership</td>
<td>SSN</td>
<td>DOB</td>
<td>Home_Street</td>
<td>City</td>
<td>State</td>
<td>Zip</td>
<td>Personal_Net_Worth</td>
<td>Annual_Household_Income</td>
<td>Monthly_Mortgage_Payment</td>
<td>Ref1_Company_Name</td>
<td>Ref1_Company_Name1</td>
<td>Ref1_Phone</td>
<td>Ref1_Company_Account</td>
<td>Ref1_Contact_Name</td>
<td>Ref2_Phone</td>
<td>Ref2_Company_Account</td>
<td>Ref2_Contact_Name</td>
<td>Ref3_Company_Name</td>
<td>Ref3_Phone</td>
<td>Ref3_Company_Account</td>
<td>Ref3_Contact_Name</td>
<td>Borrowers_Comments</td>
<td>B1</td>
<td>Referer</td>
<td>Remote_Name</td>
<td>Date</td>
<td>Time</td>
<td>Comments</td>
</tr>
<?php if($totalRows > 0) do { ?>
<tr>
<td>
<input name="firstname" type="hidden" value="<?php echo $firstname; ?>">
<input name="Business_Name" type="hidden" value="<?php echo $row_LOC2['Business_Name']; ?>">
<input name="Amount" type="hidden" value="<?php echo $row_LOC2['Amount']; ?>">
<a onClick="document.username.submit()">Edit Row</a></td>
<td><?php echo $row_LOC2 ['Amount']; ?></td>
<td><?php echo $row_LOC2 ['Business_Name']; ?></td>
<td><?php echo $row_LOC2 ['dba']; ?></td>
<td><?php echo $row_LOC2 ['Street']; ?></td>
<td><?php echo $row_LOC2 ['Business_City']; ?></td>
<td><?php echo $row_LOC2 ['Business_State']; ?></td>
<td><?php echo $row_LOC2 ['Business_Zip']; ?></td>
<td><?php echo $row_LOC2 ['Contact']; ?></td>
<td><?php echo $row_LOC2 ['Phone']; ?></td>
<td><?php echo $row_LOC2 ['Moblie_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Fax']; ?></td>
<td><?php echo $row_LOC2 ['Email']; ?></td>
<td><?php echo $row_LOC2 ['Years_in_Business']; ?></td>
<td><?php echo $row_LOC2 ['TaxID']; ?></td>
<td><?php echo $row_LOC2 ['D_and_B']; ?></td>
<td><?php echo $row_LOC2 ['Type_of_Ownership']; ?></td>
<td><?php echo $row_LOC2 ['Twelve_Month_Gross']; ?></td>
<td><?php echo $row_LOC2 ['TaxID1']; ?></td>
<td><?php echo $row_LOC2 ['Visa_Master_Sales']; ?></td>
<td><?php echo $row_LOC2 ['Equipment_Location']; ?></td>
<td><?php echo $row_LOC2 ['Average_Bank_Balance']; ?></td>
<td><?php echo $row_LOC2 ['Bank']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Account_Number']; ?></td>
<td><?php echo $row_LOC2 ['Bank_Contact']; ?></td>
<td><?php echo $row_LOC2 ['First_Name_Principal']; ?></td>
<td><?php echo $row_LOC2 ['Last_Name']; ?></td>
<td><?php echo $row_LOC2 ['Home_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Title']; ?></td>
<td><?php echo $row_LOC2 ['Percent_Ownership']; ?></td>
<td><?php echo $row_LOC2 ['SSN']; ?></td>
<td><?php echo $row_LOC2 ['DOB']; ?></td>
<td><?php echo $row_LOC2 ['Home_Street']; ?></td>
<td><?php echo $row_LOC2 ['City']; ?></td>
<td><?php echo $row_LOC2 ['State']; ?></td>
<td><?php echo $row_LOC2 ['Zip']; ?></td>
<td><?php echo $row_LOC2 ['Personal_Net_Worth']; ?></td>
<td><?php echo $row_LOC2 ['Annual_Household_Income']; ?></td>
<td><?php echo $row_LOC2 ['Monthly_Mortgage_Payment']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Name1']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref1_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref2_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Company_Name']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Phone']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Company_Account']; ?></td>
<td><?php echo $row_LOC2 ['Ref3_Contact_Name']; ?></td>
<td><?php echo $row_LOC2 ['Borrowers_Comments']; ?></td>
<td><?php echo $row_LOC2 ['B1']; ?></td>
<td><?php echo $row_LOC2 ['Referer']; ?></td>
<td><?php echo $row_LOC2 ['Remote_Name']; ?></td>
<td><?php echo $row_LOC2 ['Date']; ?></td>
<td><?php echo $row_LOC2 ['Time']; ?></td>
</tr>
<?php } while ($row_LOC2 = mysql_fetch_assoc($result));?>
</table></form>
</div>
</h3>
</body>
</html>