Transferring data from Tables

[Anon]

Hello,

Trying to insert data into a table and at the same time deleting data from the old table isn't working.

The problem:
Inserting data is functioning BUT the delete command isn't working.

Any help here would be great.
Thanks in advance !

Query I'm using:

<? include('includes/dbase.php');
if(isset($submit)){

	$ID=mysql_insert_id();

	//Insere dados na tabela de empreendimentos
	$sql ="INSERT INTO table(ID, empr, email, www, notes_cr) VALUES(null, '$empr', '$email', '$www', '$notes_cr')";
	$result=mysql_query($sql) or die("INSERT: ".mysql_error());

	//Apagar registo da tabela temporária de empreendimentos
	$sql="DELETE FROM temp_TABLE WHERE ID=$ID";
	$result=mysql_query($sql) or die("DELETE: ".mysql_error());

GET TEMP_TABLE

$sql="SELECT * FROM temp_table where ID=$ID";
$result=mysql_query($sql) or die("GET TABLE: ".mysql_error());
while ($fields=mysql_fetch_array($result)){
$empr=$fields["empr"];
$email=$fields["email"];
$www=$fields["www"];
$notes_cr=$fields["notes_cr"];
}

?>

HTML GOES HERE

[Anon]

Couldn't you just use UPDATE instead of INSERT and DELETE?

[Anon]

Hi,

Thanks for the tip but that isn't what I desire, since I want first of all to edít data that come from an online registry form and than, uppon editting, we would transfer to the final table. So update doesn't fit here.

Mario Pro

[[deleted]]

...and not working means you get an error? or what?

[Anon]

...no, in fact there is no output error but simply the data on the temp_table remains there while the insert command is inserting data quite right.
As I said before, the only problem here is that the DELETE FROM isn't deleting.