Ok this is starting to piss me off.
I have a little project and i know some basic stuff about mysql and php but i cant figure this one out.

I need to copy one row in a table to another table, so i searched for some scripts to do this and i found a sql script (thnx to original poster):

UPDATE old_data SET move="MARKED";
INSERT INTO somewhere... SELECT where move="MARKED";
DELETE FROM old_data WHERE move="MARKED";

I can run this sql query in phpmyadmin wihout any problems and it does what i need it to do the only thing is when i try to implement this in my php page i cant get this to work.
I know i need to use mysqli_multi_query (at least i think) but after 4 hours searching and trying i cant get it to work.

So if anyone can help me with this or point me in the right direction. it would help me a lot.
Thnx in advance!

Where is your php code?

Dont have a php code for it, because i have no idea how to code a multiple query and the examples in documentations echo stuff etc and i dont need all that.

It doesn't have to echo anything or something like that, the query only has to update 1 row in my database and copy it to a other table and delete the row in the old table. Nothing more, so basicly the php code just has to run the multiple query.

It will be implemented in paypal IPN, i can get 1 query to work with:

$sql="UPDATE data_temp SET check='MARKED' WHERE 'itx' = '$_POST[item_number]'";

But i have no idea how to do multiple query's.

By looking at the documentation, this is how you can do what you want to do:

PHP Code:

$query = "UPDATE old_data SET move='MARKED'";
$query .= "INSERT INTO somewhere... SELECT where move='MARKED'";
$query .= "DELETE FROM old_data WHERE move='MARKED'";

mysqli_multi_query($query); 


By the way you are open for sql injection here:

$sql="UPDATE data_temp SET check='MARKED' WHERE 'itx' = '$_POST[item_number]'";

Use mysql_real_escape_string() or in your case mysqli_real_escape_string():

PHP Code:

$item_number = mysqli_real_escape_string($_POST[item_number]);
$sql="UPDATE data_temp SET check='MARKED' WHERE 'itx' = '$item_number'"; 


Thnx for the fast response, really appreciate it!
Will try it later today.

Your post give me the little push i needed to solve it. Cost me another hour though but i got it working, finally!

So thnx again and this thread can be closed!