Row(s) kopieren tussen 2 tabellen (Opgelost)

<?php
$datatable = 'table_a';
$targettable = 'table_b';

mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('database') or die(mysql_error());

//script start hier
$fields = array();
$qFields = mysql_query('SHOW columns FROM '.$datatable) or die(mysql_error());
while($q = mysql_fetch_object($qFields))
{
	$fields[] = $q->Field;
}
$i = 0;
$qData = mysql_query('SELECT * FROM '.$datatable);
while ($q = mysql_fetch_array($qData))
{
	$data = array();
	foreach ($fields as $field)
	{
		$data[] = $q[$field];
	}
	$dataArray[] = '\''.implode('\', \'',$data);
	$i++;
}

mysql_query('INSERT INTO '.$targettable.' ('.implode(', ', $fields).') VALUES ('.implode('), (', $dataArray).')');

<?php
$datatable = 'table_a';
$targettable = 'table_b';
 
mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('database') or die(mysql_error());
 
//script start hier
$fields = array();
$qFields = mysql_query('SHOW columns FROM '.$datatable) or die(mysql_error());
while($q = mysql_fetch_object($qFields))
{
	$fields[] = $q->Field;
}
$i = 0;
$qData = mysql_query('SELECT * FROM '.$datatable);
while ($q = mysql_fetch_array($qData))
{
	$data = array();
	foreach ($fields as $field)
	{
		$data[] = $q[$field];
	}
	$dataArray[] = '\''.implode('\', \'',$data);
	$i++;
}
 
mysql_query('INSERT INTO '.$targettable.' ('.implode(', ', $fields).') VALUES ('.implode('), (', $dataArray).')');

mysql_query('INSERT INTO '.$targettable.' ('.implode(', ', $fields).') VALUES ('.implode(') (', $dataArray).')');

mysql_query('INSERT INTO '.$targettable.' ('.implode(', ', $fields).') VALUES ('.implode(') (', $dataArray).')');

insert into table_b (select * from table_a where id=1)

INSERT INTO table_b (SELECT * FROM table_a WHERE id=1)

insert into table_b (table_b.fied1,table_b.field2) (select table_a.field1,table_a.field2 from tabe_a where id=1)

INSERT INTO table_b (table_b.fied1,table_b.field2) (SELECT table_a.field1,table_a.field2 FROM tabe_a WHERE id=1)