updating several rows

[Anon]

The "update.php" script extracts the data from all the name rows and places it in input fields, so that you can change the content.

The "update2.php" script should update each row acording to the charges made, but I can only make it update the last row.

Please help!

-----------update.php-----------

<form method="post" action="update2.php>
<?php
$result = mysql_query("select * from menu");
while($row = mysql_fetch_array($result)) {
print "
<input type=text name=id value=$row[name]></input>
";}
print "<input type=submit>";
?>

-----------update2.php-----------

<?php
mysql_query("update menu set name='$navn' where $id ='???'");
?>

[sarahk]

aaah, the trap of html. Your form has a stack of inputs all with the same id so when it gets to php it doesn't know what to do.

change your print to:

$cnter++;
print " <input type=text name=id$cnter value=".$row[name]."></input> ";}

that way you will receive back $id1, $id2, etc.

Then work through all the $id fields setting $navn to the value of $id1, 2, etc. There is a way to evaluate the variable based on a concatenated string. Can't tell you off the top of my head.

good luck

[Anon]

Could you please be more specific.