$q=mysql_query("select * from tablo1"); while ($g=mysql_fetch_array($q)) { $row1=$g["row1"]; $row2=$g["row2"]; $row3=$g["row3"]; mysql_query("insert into tablo2 (row1,row2,row3) values ('$row1','$row2','$row3')"); }