Valid Query? (Insert into, values, select, where)

[gerrybytes]

Is the following a vaild query, or does any one have any suggestion on how to change it to get the correct info i'm looking for?

$Engineer = $_POST['Engineer'];
$Ref_No = $_POST['Ref_No'];
 
$query = "INSERT INTO engineer (Ref_No,Title,Forename,Surname,Email,Branch,Message,Severity,Engineer)
VALUES('$Engineer')
SELECT Ref_No,Title,Forename,Surname,Email,Branch,Message,Severity FROM new_fault
WHERE ref_no='$Ref_No'";
 
$result = mysqli_query($cxn,$query) or die ('error making query');
 

The table im trying to put info in to is called engineer. I want to input the data from table New_Fault that contains the SELECT values (Ref_No etc) also i want to put in the engineer name from the POST method.

[r035198x]

A simple modification to a SELECT INTO statement should have done the trick.

[chaarmann]

as far as I know you cannot use values() and select together.
Just make the engineer value part of the select statement. that means:

[PHP]
$Engineer = $_POST['Engineer'];
$Ref_No = $_POST['Ref_No'];

$query = "INSERT INTO engineer (Ref_No, Title, Forename, Surname, Email, Branch, Message, Severity, Engineer)
SELECT Ref_No, Title, Forename, Surname, Email, Branch, Message, Severity, '$Engineer' as Engineer FROM new_fault
WHERE ref_no='$Ref_No '";

$result = mysqli_query($c xn,$query) or die ('error making query');
[/PHP]