Insert the last table data into a second table

Question

I have a problem to give INSERT in PHP. I have a table called products_1 and another one called products_2. Table 1 has the same products as the second one, but with 5 more products, i.e., ID 11, 12, 13, 14 and 15 are not included in products_2. I need to "copy", insert this 5 products, at once, in products_2. And every time there are more products in the products_1.

I TRIED THAT, BUT HE ONLY INSERTS ID 15, THE LAST >

if (!$db->Query("SELECT * FROM produtos_2 ORDER BY id DESC LIMIT 1")) 
    $db->Kill();

while (! $db->EndOfSeek()) {
    $row = $db->Row(); 
    $idprodutos2= $row->id;
}
mysql_query("INSERT INTO produtos_2 SELECT * FROM produtos_1 WHERE id > '.$idprodutos2.'");

"Let’s go to the head together"

Answer 1

If the ids have the same value in both tables ex id 1 - café. Can make the difference of product table 1 by product 2 and use result as Insert at once.

Insert into produto2(id, descricao)    
select id, descricao from produto1 
where not exists ( select id from produto2 where id = produto1.id)

Answer 2

This instruction only entered the last one, because it is using LIMIT 1, if you know how many records you need to copy change the LIMIT. Give more details about the process, this routine is part of an external verification of the registration operation, or it needs to be in real time as a mirror table?

For the second case, a good feature would be the use of triggers (triggers), as vc can easily mount an "Insert Into Select" command and Mysql is free to fire Rigger whenever necessary.

Ref.: http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

I hope I’ve helped, if I have to set an example for you