You have an error in your SQL syntax; check the manual that corresponds to your

[Vivid Lust]

Error: 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 '' at line 3

 

Hi, i was wondering if someone could help me with this error please? I've been trying for 30 mins to get it sorted out but can't seem to, here is the code:

 

<?php
...
$sql = "INSERT INTO `films` (`name`, `director`, `releaseDate`, `type`, `genre`,
`translation`, `length`, `synopsis`, `image`, `downloadLink`, `megavideoLink`, `embeddLink` ) 
VALUES ('$name', '$director', '$releaseDate', '$type', '$genre', '$translation', '$legnth', '$synopsis', '$image', '$downloadLink', '$megavideoLink', '$embedLink'";
mysql_query($sql,$connection) or die(mysql_error());
...
?>

[Zane]

your missing the end parentheses on your VALUES