Try this...
PHP Code:
<?php
$conn = mysql_connect(" ", " ", " ")
or die(mysql_error());
mysql_select_db(" ", $conn) or die(mysql_error());
if ($_POST['submit'])
{
foreach ($_POST['ids'] as $id)
{
$id = intval($id);
$name = mysql_real_escape_string($_POST['names'][$id]);
$lastname = mysql_real_escape_string($_POST['lastnames'][$id]);
$email = mysql_real_escape_string($_POST['emails'][$id]);
$result = mysql_query("
UPDATE test_mysql
SET
name = '$name',
lastname = '$lastname',
email = '$email'
WHERE id = '$id'
");
if (!$result) die(mysql_error());
}
}
echo("
<form name='form1' method='post' action=''>
<table width='500' border='0' cellspacing='1' cellpadding='0'>
");
$query = mysql_query("
SELECT *
FROM test_mysql
");
while($row = mysql_fetch_array($query))
{
$userid = $row['id'];
echo("
<tr>
<td align='center'>
<input name='ids[]' type='hidden' id='id' value='$row[id]'>$row[id]
</td>
<td align='center'>
<input name='names[$userid]' type='text' id='name' value='$row[name]'>
</td>
<td align='center'>
<input name='lastnames[$userid]' type='text' id='lastname' value='$row[lastname]'>
</td>
<td align='center'>
<input name='emails[$userid]' type='text' id='email' value='$row[email]'>
</td>
</tr>
");
}
echo("
<tr>
<td colspan='4' align='center'>
<input type='submit' name='submit' value='Submit'>
</td>
</tr>
</table>
</form>
");
?>