[MySQL] Update Multiple Rows At Once

[Adrian Schneider]

Ok have the element names like this...

name="field[$userid]"

PHP Code:

foreach ($_POST['positions'] as $userid => $position)
{
    $userid = intval($userid);
    $position = mysql_real_escape_string($position);
    
    $hours = intval($_POST['hours'][$userid]);
    $lot = mysql_real_escape_string($_POST['lots'][$userid]);
    
    $result = mysql_query("
        UPDATE tablename
        SET
            position = '$position',
            hours = $hours,
            lot = '$lot'
        WHERE userid = $userid
    ");
    
    if (!$result) die(mysql_error());
}