please i nid help with dis for i got stuck somewhere.

I am trying to add the retrieved records from a table to another table but i can't get my query to work. dis is my code dat retrieves the records into a form
::::::::::::::::::::::::::::::::::::::::::::
<?php
require 'database.php';



$query = "SELECT id, product_title, product_price, product_img FROM products";

// run the query and store the results in the $result variable.
$result = $mysqli->query($query) or die(mysqli_error($mysqli));

if ($result) {

// create a new form and then put the results
// indto a table.
echo "<form method='post' action='submit.php'>";
echo "<table cellspacing='0' cellpadding='15'>

<th width='15%'>Image</th>
<th width='55%'>Title</th>
<th width='15%'>Price</th>
<th width='15%'>Action</th>
";


while ($row = $result->fetch_object()) {

$title = $row->product_title;
$price = $row->product_price;
$image = $row->product_img;
$id = $row->id;

//put each record into a new table row with a checkbox
echo "<tr>
<td><img src='$image' /></td>
<td>$title</td><td>$price</td>
<td><input name='color[]' type='checkbox' value='Blue'/>Bl
<input name='color[]' type='checkbox' value='Green'/>G
<input name='color[]' type='checkbox' value='Yellow'/>Y
<input name='color[]' type='checkbox' value='Black'/>Bl
<input id='submit' type='submit' class='button' name='submit' value='Submit Selected Items'/>
</tr>";

}

// when the loop is complete, close off the list.
echo "</table><p></p></form>";
}

?>
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Dis is the submit section where the reords go into another table:

<?php

require 'database.php';

if($_POST['submit']) // from button name="delete"
{


$colors = $_REQUEST['color'];

foreach($colors as $color)
//{
for($i=0; $i< count($color); $i++)


{

$copy = "SELECT id, product_title, product_price, product_img FROM products";

// run the query and store the results in the $result variable.
$result = $mysqli->query($copy) or die(mysqli_error($mysqli));



$sql ="INSERT INTO `approve` (`pro_id`,`product_title`, `product_price`, `product_img`,`date`) VALUES('$color','" . $copy['product_title'] . "', '". $copy['product_price'] . "', '" . $copy['product_img'] . "',NOW())";
//$sql = "DELETE from products where id = $del_id";
$result = $mysqli->query($sql) or die(mysqli_error($mysqli));

}
if($result)
{
header('Location: index2.php');
}
else
{
echo "Error: ".mysql_error();
}
}
?>


pls i nid help quick