Tuesday, 15 April 2014

mysql - when i will run this query it will give an error -



mysql - when i will run this query it will give an error -

you have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'specific) values ('5.jpg','kids','anyone')' @ line 1,,

my query

$sql="insert imagetable(image,name,specific) values ('$dbimage','$dbname','dbspec')";

specific reserved word in mysql. either utilize backticks escape or utilize name column.

insert imagetable (image, name, `specific`) values ('$dbimage','$dbname','dbspec')

mysql

No comments:

Post a Comment