mysql - PHP Insert data from one table to another -

i trying insert data 1 table another, , error message get:

error: insert content2 (d1, d2, d3) values (john, doo, 24);

unknown column 'john' in 'field list'error: insert content2 (d1, d2, d3) values (mary, moe, 36);

unknown column 'mary' in 'field list'error: insert content2 (d1, d2, d3) values (julie, dooley, 42)

unknown column 'julie' in 'field list'error: insert content2 (d1, d2, d3) values (john, doo, 24);

unknown column 'john' in 'field list'error: insert content2 (d1, d2, d3) values (mary, moe, 36);

unknown column 'mary' in 'field list'error: insert content2 (d1, d2, d3) values (julie, dooley, 42);

unknown column 'julie' in 'field list'

here php code:

//get connection require_once('connect.php');  //get data $sql = "select d1, d2, d3 content"; $result = mysqli_query($con, $sql);  if (mysqli_num_rows($result) > 0) { // output data of each row     while($row = mysqli_fetch_assoc($result)) {         $row1 = $row["d1"];         $row2 = $row["d2"];         $row3 = $row["d3"];  //insert data table             $sql = "insert content2 (d1, d2, d3)             values ($row1, $row2, $row3);";             if (mysqli_multi_query($con, $sql)) {                 echo "new records created successfully";             } else {                 echo "error: " . $sql . "<br>" . mysqli_error($con);             }         //echo "id: " . $row["d1"]. " - name: " . $row["d2"]. " " . $row["d3"]. "<br>";     } } else {     echo "0 results"; } 

i couldn't figure out problem are. please help

when php sends insertion query mysql, ends looking this:

insert content2 (d1, d2, d3) values (john, mary, julie); 

because there no quotation marks around “john”, “mary”, , “julie”, mysql thinks you're referring other column names. quick , dirty solution add quotation marks query, @tadman says, should not ever using style of query, , should instead use bind_param add variables query.

however, if want copy 1 table another, @dan bracuk says, can single query:

insert content2 (d1, d2, d3) select d1, d2, d3 content