Simple MySQL query question

Question

How would I do this (the part in square brackets):

$name = 'Bob';

mysql_query("INSERT INTO table(field1,field2) 
[ select value of field1 from another table ], '$name'");

Asaph · Accepted Answer · 2009-10-26 03:13:49Z

5

The SQL part of it might look like this:

INSERT INTO table1 (field1, field2) SELECT field1, 'Bob' FROM table2 WHERE ...

Dynamically constructing that in PHP is a simple exercise I leave up to the reader :)

answered Oct 26, 2009 at 3:13

Asaph

163k25 gold badges204 silver badges204 bronze badges

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

1 Answer 1