[MySQL] Update Multiple Rows At Once

[evenmonkeys]

I'm not getting it to work. I made a test database with some information that's easy to work with. Can you modify this set of code so that it should work? I honestly don't understand much of this right now because of what I know, none of this even looks like it'd even work to me. Haha. I'd really appreciate it.

<?php

$conn = mysql_connect(" ", " ", " ")
or die(mysql_error());
mysql_select_db(" ",$conn) or die(mysql_error());

if($_POST[submit]){

  foreach($_POST['name'] as $id => $name){
    $id = intval($id);
    $name = mysql_real_escape_string($name);
    $lastname = mysql_real_escape_string($_POST['lastname']);
    $email = mysql_real_escape_string($_POST['email'][$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)){
echo("

        <tr>
          <td align='center'>
<input name='field[$id]' type='hidden' id='id' value='$row[id]'>$row[id]
          </td>
          <td align='center'>
<input name='field[$name]' type='text' id='name' value='$row[name]'>
          </td>
          <td align='center'>
<input name='field[$lastname]' type='text' id='lastname' value='$row[lastname]'>
          </td>
          <td align='center'>
<input name='field[$email]' 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>

");
?>

I'm either getting errors or nothing at all... or it's deleting rows. O_o Sometimes it says there's a syntax error on line 12. Sometimes it says there's no match for an entry. Then when I added [$id] after lastname, it started deleting the last row and rearranging the other fields in other rows. Lol. PHP hates me.