Copy Data to second table

[cswales]

Hi
What I need to achieve is the following:

I need to create a button to run a script that will take data from table 1 where the values in columnX are false. I then need the data to enter into table2.

There will be many records for one customer in table1 so when being transferred to table 2 should be grouped and given the same reference number in ColumnY (tbl2).

When the transfer is completed columnX in table1 for transferred records shoudl change to true.

Any help on any part of this script is highly appreciated.

[devinemke]

a basic example

// connect to db here

$result1 = mysql_query('SELECT * FROM table1 WHERE columnx IS NULL') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result1))
{
	foreach ($row as $key => $value)
	{
		$row[$key] =  $key . " = '" . addslashes($value) . "'";
	}	
	$result2 = mysql_query('INSERT INTO table2 SET ' . implode(',', $row)) or exit(mysql_error());

$table1_ids[] = $row['id'];
}

$result = mysql_query('UPDATET table1 SET columnx = 1 WHERE id IN(' . implode(',', $table1_ids) . ')') or exit(mysql_error());