Tell me more ×  Hi all i'm trying to save data to database and i
get an error i never saw before i have a hunch it has something
to do with the db collation but I'm not sure whats wrong,  here
is the query:  $query1 = "INSERT INTO scape.url
(url,normalizedurl,service,idinservice) VALUES (url,
normalizedurl, 4, 45454)";             $query = "INSERT INTO
scape.url (url, normalizedurl, service, idinservice) VALUES ("
$result = $sql->query($query);             echo $sql->error;
the error massage i get is :  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
'://www.something/here/here/here/12345,httpwwwsomthighere' at
line 1  database collation for this fields is utf8-general-ci
and field type is varchar 255  any ideas on that?  share|improve
this question add comment  1 Answer  up vote 1 down vote
accepted  If you do it this way, you still have to put quotes
around the strings (url and normalizedurl). That's the synta