insert into 'error in your SQL syntax'

[don11]

I am getting this error while trying to insert data into table from html form:

Could not enter data: 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 'contact,name,age,email' at line 1

 

I was trying like this:

$sql = "INSERT INTO mytablename ".
       "(contact,name,age,email,............so on...to 108 colonms) ".
       "VALUES ".
       "('$contact','$name','$age','$email',........so on....to 108 values)";

[Pikachu2000]

Echo the query string and see what it actually holds. If it looks OK, paste it in to phpMyAdmin and execute it there and see if you get the same error.

 

There's no need to end the quotes and concatenate just to move to the next line in your editor.; you can simply omit that and it makes no difference to php if the query spans multiple lines, BTW.

[don11]

echo shows everything fine and in phpmyadmin, showing same error msg, what to do now

[don11]

problem is solved now, it was line break issue, thanks