Error: Duplicate Entry, simple edit form

[TCombs]

I have a table called "colors".  It has 2 columns, id and color.

 

All I'm trying to do is pull the data into the form, then edit the colors (for example - misspelled, etc.)

Then submit it back to the table.

 

Here is the code that pulls the data into a form so I can edit it:

<form action="adminupdatecolors.php" method="post">

<table width="500" border="1" cellpadding="10">

<tr>
  	<td>Color Options:</td>
    <td>
    <?		
		$result = mysql_query("SELECT * FROM colors");
		while ($row = mysql_fetch_assoc($result)) {

			echo '<input type="text" name="color[]" value="' . $row['color'] . '"/>' . $row['id'] . '<br />';
		}

		?>
   </td>
</tr>

   <tr>
  	<td> </td>
  	<td><input type="Submit" value="Update Colors"></td>
  </tr>
</form>
</table>

 

 

Here is my update script:

<?php

include("config.php");
include("db.php");

$id=$_POST['id'];
$color=$_POST['color'];

$result = mysql_query("SELECT id FROM colors ORDER BY id DESC LIMIT 0,1");

if ($row = mysql_fetch_assoc($result)) {
$id = $row['id']; 
}
$sql = "DELETE FROM colors WHERE id='$id'";
mysql_query($sql) or die("Error: ".mysql_error());

foreach ($color as $colorvalue) {
	$sql2 = "INSERT INTO colors (id,color) VALUES ($id,'$color')";
	mysql_query($sql2) or die("Error: ".mysql_error());

}

header("Location: " . $config_basedir . "adminhome.php");

?>