dynamic form issue

[Anon]

I am trying to generate form text fields on the fly and then update all of them at once with new values submitted to a database. I will almost always have more than one field generated. So far with the code I have below I am able to always update the last occurance, but none of the fields that come before get updated. This is probably due to the fact that I have the same name for each generated field and the update query is defaulting to the last one supplied. Does anyone have ideas as to how I can update each field occurance in the database in this way? Maybe from the update query end...

Here is the code:

<form method="get" action="index.php" name="update">
<?

$sqlQuery = "sql query goes here...";
$sqlQueryResults = mysql_query($sqlQuery, $mysql_link);

//loop thru results and display a new pre-filled text field for each result

while ($getRow = mysql_fetch_array ($sqlQueryResults)) {
?>

<? print("<tr>
<td>

  //varName is a primary key

      <input type=\"hidden\" name=\"varName\" value=\"" .$getRow[varName]."\">

      //varName2 is a the text field to be updated

      <input type="text" name=\"varName2\" value=\"" . $getRow[varName2] . "\"></td> 

print("<tr><td colspan=\"4\"><hr noshade color=\"#BBD400\"></td></tr>");
}

//print one submit button for dynamically generated form fields

print("<tr><td colspan=\"4\"><input type=\"submit\" value=\"edit field name\"></td></tr>");
}

?>
</form>

//action code upon submition of form

if (isset($varName2)){
$updateTextField = "UPDATE database.table SET varName2='$varName2' WHERE varName='$varName'";
mysql_query($updateTextField,$mysql_link);

[chowdary]

Hi,
If i am not mistaken the problem is,your dynamically generated form will be having more than one text field and a hidden field associated with each text field(which hold the value of the primary key associated with that row) and you want to update the database once this form is submited with new values but,now you are able to update last value only.........am i right....If that is the issue here is the solution.

 First you need to give different field names while generating the form.

  in the while loop use this script to generate different field names

   $count=$count+1;
// varName (Primary Key)
   $pk_field_name="varName".$count;
// varName2 (Text Field Name)
   $txt_name="varName2".$count;

in your code above use these variables
to assing the value to the name attribute

i.e in hidden field name=\"$pk_field_name\"
and in text filed name=\"$txt_name\"

after while loop place one more hidden field which holds value of total number of fields

<input type="hidden" name="tot_fields" value=\"$count\">

Now comes to the submition part you need to gothrough loop to update all fields.

here is the code
for($i=1;$i<=$tot_fields;$i++)
{
$hide_field_name="varName".$i;
$text_field_name="varName2".$i;

   $hide_field_val=$$hide_field_name;
   $text_field_name=$$text_field_name;

  //Query will be

 $qry="update $table_name set varName2='$text_field_val' where varName=$hide_field_val";

  // execute query

}

Hope this works......Enjoy

[Anon]

2 things I don't quite get...

1. What does the "." do in $txt_name="varName2".$count;

2. In the query you use $text_field_val did you mean $text_field_name? Cuz I don't see a $text_field_val in the preceeding code.

Other than that this makes sense, I havn't had a chance to implement it yet, but thank you very much for taking the time to help me out.

[chowdary]

I think varName and varName2 are Field Names in your database if it is...Then only the code works to avoid confusion make the following changes
Replace "varName" with "hid_fld"
Replace "varName2" with "txt_fld"
(Both in two places)

Now in the query replace varName and varName2 with exact field names

Let me clear your doubts

$txt_name="varName2".$count (Now it will be $txt_name="txt_fld".$count isn't it?)

is to generate field names to text fields
If your form has three text fields then names wil be "txt_fld1","txt_fld2","txt_fld3"
OK

Second one I am Sorry.....typing mistake....
Change $text_field_name=$$text_field_name;
To $text_field_val=$$text_field_name;

Hope i am clear......