PHP run SQL result in another SQL statement

Question

Is this possible? I need to run the result of one sql statement into another..

$result= mysqli_query($dbconn,"Select max(cartid) from cart;");
$row = mysqli_fetch_assoc($result);

$sql1 = "insert into cart(cartid) values('".$row['max(cartid)']."');";
mysqli_query($dbconn,$mysql1);

EDIT:

Added in my sql tables to show a better example of what im trying to do This is my cart table

This is my transaction table

Basically I want to transfer the row where cartid = 5 from cart table, into the transaction table where the new transaction id will be = 5. As you can see, the transaction table also has a cartid. Not sure how im going to bring over this cartid and insert into the transaction table as a new row. FYI, in order to get cartid=5 i would like to use order by cartid desc limit 1 to get the last possible row in the cart table

The new transaction table's row will look something like this.

transactionid outletid nric cartid transactiondate totalbeforediscount totalafterdiscount transactiontime username
     5           0      0     5         0                 0                       0                 0            0

Is the only purpose for retrieving the data in the first query ($result) to then use it in the second - or - will you be using that data elsewhere as well? — Nick
– Nick, Commented Jul 24, 2016 at 5:27

1000111 · Accepted Answer · 2016-07-24 07:01:59Z

2

You can combine the queries into one.

Please give it a try:

INSERT INTO cart(cartid) SELECT MAX(cartid) FROM cart

WORKING DEMO

EDIT:

In order to insert mulitiple values like that your query would look like below:

INSERT INTO cart(cartid,rowid) SELECT MAX(cartid),MAX(rowid) FROM cart

WORKING DEMO

But I don't understand why are trying to insert the columns having max value in the same table. Since your table contains those already.

Edit2:

INSERT INTO transaction_table(cartid) SELECT MAX(cartid) FROM cart;

edited Jul 24, 2016 at 7:01

answered Jul 24, 2016 at 5:25

1000111

13.5k2 gold badges32 silver badges43 bronze badges

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

9 Comments

mctjl_1997 Over a year ago

hmm, how about if lets say i want to insert multiple values from different tables? Maybe like this? "Insert into cart(cartid,rowid) Select Max(cartid) from cart,Select Max(rowid) from row"

mctjl_1997 Over a year ago

What if my rowid comes from another table? Sorry im just using an example

1000111 Over a year ago

Then I guess you need to share actually what are you intending to do.

mctjl_1997 Over a year ago

I will be getting a few result from some sql statements. And i want to place all these results together into one insert sql statement. So i will then be inserting values of these different results i got, into one sql table. However the results that i am getting are mostly from other tables.. Sorry if i'm not explaining it well enough. I'm not sure why the way i'm doing isnt correct, by storing each result into a PHP variable then using it in another SQL statement

1000111 Over a year ago

Then please share the table structures of all the related tables. Without prior knowledge of which data come from which table I cannot provide any help.

|

Collectives™ on Stack Overflow

PHP run SQL result in another SQL statement

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related