MySQL query error in inner join

Question

I faced an error, I want to take username from member table and image path from uploading directory and my image is is autoincrement.

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

I got following error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inner join member on profileimage.username=member.username' at 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

You should be using the following to select with insert:

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: The column numbers must be the same.