// find out how many records there are to update $size = count($_POST['Name']); // start a loop in order to update each record $i = 0; while ($i < $size) { // define each variable $Name= $_POST['Name'][$i]; $id = $_POST['id'][$i]; $area = $_POST['area'][$i]; $url = $_POST['url'][$i]; // do the update and print out some info just to provide some visual feedback $query = "UPDATE `links` SET `Name` = '$Name', `url` = '$url',`area` = '$area' WHERE `id` = '$id' LIMIT 1"; mysql_query($query) or die ("Error in query: $query"); print "
$Name $url $area


"; ++$i; } mysql_close(); ?>