Combine php variable and SELECT variables into one SQL Insert query

Question

I've the following query:

INSERT INTO 
                                table
                            (
                                memberid,
                                field1,
                                field2,
                                field3
                            )  
                            VALUES
                            (
                                :memberid,              
                                (
                                    SELECT
                                        field1,
                                        field2,
                                        field3
                                    FROM 
                                        table
                                    WHERE 
                                        id = :id
                                )
                            )

I'm using PDO prepared statements, but the query doesn't work in this way.

Does anyone know how to combine prepared statements and SELECT variables into one query?

Tnx

I'm sorry Victor. I didn't know this feature is available. I will remember that in the future! — Arjen
– Arjen, Commented Aug 11, 2010 at 16:23
Please don’t answer on your own question if you don’t have an answer to your question. — Gumbo
– Gumbo, Commented Aug 11, 2010 at 16:32

Victor Nicollet · Accepted Answer · 2010-08-11 16:08:50Z

3

Have you considered insert-select?

INSERT INTO mytable (a,b) 
SELECT :a, b
FROM myothertable

answered Aug 11, 2010 at 16:08

Victor Nicollet

24.7k4 gold badges62 silver badges90 bronze badges

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

3 Comments

Arjen Over a year ago

I've tried that, but that isn't working. I get this error: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 in

Victor Nicollet Over a year ago

You're probably using code like "INSERT INTO (a,b,c) SELECT a,b". Post the actual query and we'll count the columns and values for you.

Arjen Over a year ago

Thank you. I made a mistake with setting the VALUES parameter (thanks Gumbo)

Collectives™ on Stack Overflow

Combine php variable and SELECT variables into one SQL Insert query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related