MySql/PHP Insert and Delete problem

[Anon]

Hello,

The objective:
Trying to insert data (sent to the temporary table from online form) into a final table and at the same time deleting data from the old temporary table.

The problem:
Inserting data from editing is functioning BUT the DELETE command isn't working, since when the update button is pressed, the data remains in the temporary table.

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]

This is your code:

$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());

You're getting the $ID BEFORE you insert! How will MySQL know what the insert ID will be before you insert? Therefore, put $ID = ... after the mysql_query.

Diego

[Anon]

Thanks for the tip but the problem isn't with the insert command but with the DELETE FROM. As I said, sql is inserting but not deleting, even though your tip was correct and was an error of mine.
Fixing this doesn't solve the problem.

[Anon]

Oooh, ok, sorry, that wasn't a problem either. The problem is that the ID in the temp_table and the original table may be different. So you can't get the insert ID either. Somehow you have to get the ID of the temp_table.

Diego