title: SQL error: check the manual that corresponds to your MySQL server version for the right syntax,
body: <p>Uploading an image to a folder in a server and saving the path to this image in a SQL database, I'm achieving the error below.</p>
  
  <blockquote>
    <p>error in INSERT into 'offerstbl' ('ImagesPath','SubmissionDate') VALUES ('images/29-07-2014-1406647868.png','2014-07-29') == ----> 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 ''offerstbl' ('ImagesPath','SubmissionDate') VALUES ('images/29-07-2014-1406647' at line 1</p>
  </blockquote>
  
  <p>PHP CODE</p>
  
  <pre><code> function GetImageExtension($imagetype)
   {
     if(empty($imagetype)) return false;
     switch($imagetype)
     {
         case 'image/bmp': return '.bmp';
         case 'image/gif': return '.gif';
         case 'image/jpeg': return '.jpg';
         case 'image/png': return '.png';
         default: return false;
     }
   }
  
  
  
  if (!empty($_FILES["uploadedimage"]["name"])) {
  
  $file_name=$_FILES["uploadedimage"]["name"];
  $temp_name=$_FILES["uploadedimage"]["tmp_name"];
  $imgtype=$_FILES["uploadedimage"]["type"];
  $ext= GetImageExtension($imgtype);
  $imagename=date("d-m-Y")."-".time().$ext;
  $target_path = "images/".$imagename;
  
  
  if(move_uploaded_file($temp_name, $target_path)) {
  
  $query_upload="INSERT into 'offerstbl' ('ImagesPath"','"SubmissionDate') VALUES 
  
  ('".$target_path."','".date("Y-m-d")."')";
  mysql_query($query_upload) or die("error in $query_upload == ----&gt; ".mysql_error());  
  
  }else{
  
  exit("Error While uploading image on the server");
  } 
  
  }
  
  ?&gt;
  
  &lt;/html&gt;
  </code></pre>
  
  <p>MySQL code</p>
  
  <pre><code> INSERT INTO `offerstbl`(`ImagesId`, `ImagesPath`, `SubmissionDate`) VALUES ([value-1],[value-2],[value-3])
  </code></pre>