html form to edit all rows in a table?

[showdown]

Howdy all,

Is it possible to use php to create an html form where each row from a mySql table is displayed with the current data values as the default values in the form input fields and then to have all of the rows and their fields be updated on form submit?

I would like to enable the "bulk editing" of all the records in a table through a simple html form... The catch is that I'd like to have all of the rows displayed at once in a big form and to be able to go through and make the edits and then submit the form and have all the rows updated at the same time...

I'm sure I'd be able to do this for one row but I don't really know how to go about doing it for all the rows in the table...

Any suggestions as to where I should start or any resources... or better yet, anyone have some code to share... 😉

Thanks in advance

[devinemke]

a VERY simple example (without proper form input validation):

<?php
if (!isset($_POST['submit']))
{
	echo '<form action="" method="post">';

$result = mysql_query('SELECT id, name, email FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	extract($row);

	echo '
	id: ' . $id . '<br>
	name: <input type="text" name="data[' . $id . '][name]" value="' . $name . '"><br>
	email: <input type="text" name="data[' . $id . '][email]" value="' . $email . '"><br>
	<hr>
	';
}

echo '<input type="submit" name="submit" value="submit"></form>';
}
else
{
	foreach ($_POST['data'] as $key => $value)
	{
		extract($value);
		$sql = "UPDATE table SET name = '$name', email = '$email' WHERE id = $key";
		$result = mysql_query($sql) or exit(mysql_error());
		echo $id . ' UPDATED<br>';
	}
}
?>

[showdown]

Awesome! Thanks SO much- This is the starting point I was hoping for...