Looping forms

[klavis]

Hey,
I am trying to set up a dynamic table with forms in it. Basically not to go into to much detail its a table of rooms with a "Request Me" button at the end of each row...when someone clicks on the request me button the idea is to have the building and room number stored into a field in a database. The problem i am having is that because the forms are basically all the same no matter which button you push the value of the bottom field is always whats stored in the database?? I cant seem to think of a better way to do this...here is the code for the loop that builds my table.

for ($i=0; $i <$num_results; $i++) {
echo "<font color=white face=\"Geneva, Arial, Helvetica, sans-serif\" >";
echo "<tr><td width = 35%>";
$row = mysql_fetch_array($result);
$buildRoom[$i] = $row["building"]."-".$row["room"];
echo "<img src=\"".htmlspecialchars( stripslashes($row["picture"]))."\" alt=\"No Image Available\">";
echo "</td>";
echo "<td> ";
echo "<strong>";
echo htmlspecialchars( stripslashes($row["name"]));
echo "</strong><br>";
echo htmlspecialchars( stripslashes($row["building"]));
echo "-";
echo htmlspecialchars( stripslashes($row["room"]));
echo "</td>";
echo "<td>";
echo htmlspecialchars( stripslashes($row[$style."_cap"]));
echo "</td>";
echo "<td>&nbsp;";
echo htmlspecialchars( stripslashes($row["av_equip"]));
echo "</td>";
echo "<td>&nbsp;";
echo htmlspecialchars( stripslashes($row["furnature"]));
echo "</td>";
//at the end of the row add a small form with just the value of the building and room number
//these valuse will be entered into the form when requestform.php3 is processed
echo "<form action =\"requestform.php3\" method = \"get\">";
echo "<input type=hidden name=roomNum value=".$buildRoom[$i].">";
echo "<td><center> <input name=\"submit\" type=\"submit\" value=\"Request Me!\"></center>";
}

Thanks soo much for your help...

Keith Mancuso

[xblue]

you open the form within the loop, but you don't seem to close it. thus it is all treated as one huge form, where the inputs with the same name overwrite each other.

[barand]

I cannot see that $buildroom needs to be an array.

$buildRoom = $row["building"]."-".$row["room"];

and, later,

echo "<input type=hidden name=roomNum value=\"$buildRoom\">";

should suffice.

You could also do it just with a link instead of a form by putting

<a href="requestform.php3?roomNum=$buildroom&submit=Request+me">Request me</a>!

in the last column of each row.

hth

[Cynthia_Blue]

I have a question similar to this, and from this post I still cannot get it to work right. 🙂

I'm building a table which displays the information in the table. The left most table field will be a Load button to load that entry. So what I need is for the name of the variable to increment, but the value of the variable to reflect the key field inside the table. :p

When I use a loop, and if I use the same var name, the variable is changed each time to the most recently pulled in value. So no matter which button is clicked, only the last one will appear. :p

Here is my code (lots of echos so I can see variables -- this is not working how I want it to):

         while($rowresults = sybase_fetch_row($searchresults)) { 
           while(list($krow, $vcells) = each($rowresults)) { 
		     if ($firsttime=="yes") {
			   $loadform='$vcells' . $forminc;
			   echo "loadform: $loadform";
			   echo "<td><input type='submit' name='selectlog' value='Load'><input type='hidden' name='hiddenlog' value='$loadform'>$loadform</td>";
			   $firsttime="no";
			   $forminc++;
		     }
		     if ($countme >= 9) {
 			   $loadform='$vcells' . $forminc;
			   echo "loadform: $loadform";
			   echo "</tr><td><input type='submit' name='selectlog' value='Load'><input type='hidden' name='hiddenlog' value='$loadform'>$loadform</td>";
			   $countme=0;
			   $forminc++; 
			 }
			 if (($krow==0) or ($krow==7) or ($krow==8)) {
			   // Don't print the key field, the long description or the long resolution.
               // echo "<td>$krow</td>";
			 } else {
			   echo "<td class='underbold' align='left' valign='top'>$vcells</td>"; 
			 }
		   $countme++;
           } 
         }