MySQL query error in internal connection

Question

I encountered an error, I want to take the username from the member table and the path to the sample from the download directory, and my image is an auto-increment.

INSERT INTO profileimage SET `imageid`='', `username`='username', `imagepath`='$target_file' inner join member on profileimage.username=member.username; 

I got the following error

1064 - You have an error in the SQL syntax; check the manual that matches your MySQL server version for the correct syntax to use next to 'internal join member on profileimage.username = member.username' on line 5

My PHP script is here

 <?php error_reporting(E_ALL ^ E_NOTICE); include('configdb.php'); if (isset($_POST['submit'])) { $target_dir = "../Photos/"; $target_file = $target_dir . basename($_FILES["file"]["name"]); $uploadOk = 1; $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION); if(isset($_POST["submit"])) { $check = getimagesize($_FILES["file"]["tmp_name"]); if($check !== false) { echo "File is an image - " . $check["mime"] . "."; $uploadOk = 1; } else { echo "File is not an image."; $uploadOk = 0; } } if (file_exists($target_file)) { $target_file = $target_dir . rand(1,100000) . basename($_FILES["file"]["name"]); $uploadOk = 1; } if ($_FILES["file"]["size"] > 600000) { echo "Sorry, your file is too large."; $uploadOk = 0; } if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif" ) { echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed."; $uploadOk = 0; } if ($uploadOk == 0) { echo "Sorry, your file was not uploaded."; } else if(move_uploaded_file($_FILES["file"]["tmp_name"], $$target_dir.$target_file)) { $QueryInsertFile="INSERT INTO imgstore SET `imgpath`='$target_file'"; } else { echo "Sorry, there was an error uploading your file."; } } ?> 

Answer 1

To select with an insert, you should use the following:

 INSERT INTO ProfileImage(col1, col2) SELECT col1, col2 FROM member m INNER JOIN AnyTable k ON m.Col1 = k.Col1 WHERE m.username = 'John' 

Note: Column numbers must be the same.