multiple row updates

[jpn]

Hello all,

I have been asked to write a small program that will update data held in a MYSQL table.

The table will contain around 75 rows of data and will NOT grow in size.

Lets say the table is as follows:
ID, Name, Address.

My first thought was to have a list all of the names. The user would then click on the a name which would then take them to a form that would allow him / her to make changes.

Then I thought, this could be cumbersome at 75 times a day.

Is it possible to show a table of text boxes etc with 1 update buttton at the bottom. Once the user had entered the relevent data they would only have click UPDATE once.

Hope this makes sense!

John

[Bozebo]

well... lets see:

if(isset($_POST['complete'])){
for($id = 1;$id <= 75;$id++){
$this_name = $_POST['name_'. $id];
$this_address = $_POST['address_'. $id];
$this_update_q = "UPDATE table SET name = '$this_name', address = $this_address WHERE id = $id";
mysql_query($this_update_q);
}
} else {
$current_data_q = "SELECT * FROM tablename WHERE id < 76 LIMIT 75";
$current_data = mysql_query($current_data_q) or die(mysql_error());
echo '<form method="post">';
while($row = mysql_fetch_assoc($current_data)){
echo 'Name: <input type="text" name="name_'. $row['id'] .'" value="'. $row['name'] .'"/><br />';
echo 'Address: <input type="text" name="address_'. $row['id'] .'" value="'. $row['address'] .'"/><br />';
}
echo '<input type="submit" name="complete" value="complete" /></form>';
}

Ok, remember to validate the inputs, and you could put a javascript thing and a hidden field calld changed, and have it set to true onkeyup of the fields, so that it doesnt loop through un-altered records

Does that do it for you? If you need more help, ask.