Member Avatar for ifezuec

my php is telling me that my insertion syntax is not appropraitw for the version of mysql(5.1.41) i am using.
i tried this: $sql = "INSERT INTO `comments` ('user' ,'pass','comment')VALUES ($user, $pass, $comment);";

and the PHP is giving me :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 ''user' ,'pass','comment')VALUES (, , )' at line 1

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

Use backticks for column names instead of apostrophes (or omit them if your column names don't contain blanks), but use apostrophes around the field content. Do not use a semicolon inside the statement if you submit it using PHP.

$sql = "INSERT INTO `comments` (user ,pass,comment) VALUES ('$user', '$pass', '$comment')";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.