PHP How to use a Insert Query and a Delete Query in Conjunction

Question

I searched a great deal for a solution to this problem, however i have had no luck in finding an answer, i am trying to archive a row from one table to another and then delete the row from the original table. I have the code set up how i think it should be but it only moves the record it does not delete it from the Original table.

mysql_connect('localhost', 'brokensky', 'password');
mysql_select_db('isad235database');

$select = filter_var($_POST['selectlist'],FILTER_SANITIZE_STRING);

$query = "INSERT INTO `serversarchive` (`Server_ID`,`Server_name` , `Location` , `MAC_Address` , `Port_Number` , `IP_Address`, `Operating_System`, `Administrator`, `Contact_Number`, `Email` , `Second_Contact`, `Second_Contact_Number`, `Comments`)
SELECT * FROM `servers`
WHERE `Server_ID` = '$select'; DELETE FROM server WHERE Server_ID = = '$select'";

As i have looked around for several hours with no decent answer to this, i think this could be useful to others also.

you cant use multiple queries in one mysql_query() function call — user557846
– user557846, Commented Jan 27, 2015 at 19:26

Community · Accepted Answer · 2017-05-23 11:43:31Z

2

You need to do the steps in sequence. If they need to happen as an atomic unit, use a transaction.

See also: PHP + MySQL transactions examples

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jan 27, 2015 at 19:26

PaulProgrammer

18k4 gold badges46 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daniel W. Over a year ago

Why can't he use multi query, supported by mysqlnd for example?

PaulProgrammer Over a year ago

@DanFromGermany mysqlnd is not well supported on budget-oriented hosts. Best to stick to the basics. Anyway, I'm not familiar with it -- perhaps you want to write an answer?

Riad · Accepted Answer · 2015-01-28 11:49:21Z

0

You need to execute sequentially.

$query = "INSERT INTO `serversarchive` (`Server_ID`,`Server_name` , `Location` , `MAC_Address` , `Port_Number` , `IP_Address`, `Operating_System`, `Administrator`, `Contact_Number`, `Email` , `Second_Contact`, `Second_Contact_Number`, `Comments`)
SELECT * FROM `servers`
WHERE `Server_ID` = '$select'"; 

//execute first  

$query2 = "DELETE FROM server WHERE Server_ID = '$select'"; // == should be single =

//now execute this one.

edited Jan 28, 2015 at 11:49

answered Jan 27, 2015 at 19:28

Riad

3,8585 gold badges30 silver badges39 bronze badges

2 Comments

bSky Over a year ago

This still does not work only the move is done the deletion of the record does not happen.

Riad Over a year ago

simple mistake...you are using double equals..(= = ) ..it should be single =. corrected.

Collectives™ on Stack Overflow

PHP How to use a Insert Query and a Delete Query in Conjunction

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related