Insert Into

[Solar]

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 'like (comment_id, name, like) VALUES ('102','Steven','1')' at line 1

 

$sql="INSERT INTO like (comment_id, name, like)
VALUES
('$_POST[comment_id]','$_POST[name]','$_POST[like]')";
  
if (!mysql_query($sql,$con))
  {
  die('Error:' . mysql_error());
  }
echo "You have succesfully liked this comment.<br /><INPUT TYPE=\"button\" VALUE=\"Back\" onClick=\"history.go(-1);\">";

mysql_close($con)

 

Table:

comment_idnamelike

 

For some reason, I cannot spot this error. Can you find it? My $con = mysql_connect is a part I left out but it connects fine! The data form is echo'ing fine but it's not inserting into the MySQL Table.

 

Thanks in Advanced!

[gizmola]

like is a mysql keyword.  You have to put `like` where you used it for the tablename and columnname.

 

$sql="INSERT INTO `like` (comment_id, name, `like`)

[Solar]

Thanks for the fast reply! Wow, I didn't know it was a keyword!

I'll run to google and search MYSQL KEYWORDS

It will save a lot of pain for next time

 

Cheers

[gizmola]

Sure no worries... LIKE comes up with select queries ala  ... SELECT from people where lastname LIKE 'Smit%';