MYSQL Syntax - Insert statement

Question

Struggling with a simple insert command, i'm getting the 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 'All In: 
The Poker Movie, tells the story of poker focusing on why one of our nat' 
at line 2"

Basically passing film information into a table, here is the code -

$query1 = "INSERT INTO Films_Info (Films_ID,FilmName, FilmRelease, Synopsis,Poster,CritScore,AudScore,Director,Studio,IMDB,date_added_db) 
VALUES ('',$Film_Name', '$Film_Release','$filmsynopsis','$film_image','$film_critic','$film_audience','$film_director','$film_studio','$film_imdbID','')";
$runquery1 = mysql_query($query1)or die(mysql_error());

Thanks guys

$Film_Name' this bit is missing the opening quote I believe — Dale
– Dale, Commented Apr 17, 2012 at 23:26
You should also pass through mysql_real_escape_string() not par-sey for any sql injections you may have but to escape any quotes ect that will break your query. — Lawrence Cherone
– Lawrence Cherone, Commented Apr 17, 2012 at 23:35

David Z. · Accepted Answer · 2012-04-17 23:26:22Z

7

It looks like that you are missing an ' before $Film_Name. Can you add the missing apostrophe?

answered Apr 17, 2012 at 23:26

David Z.

5,7012 gold badges22 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DIM3NSION Over a year ago

That fixed that error but its still giving a sql syntax error, saying its near a part of the entered data?

Jay · Accepted Answer · 2012-04-17 23:31:01Z

1

If you have phpmyadmin enabled on you server, you can paste the code into the SQL-Field to get syntax highlighting on the SQL query.

answered Apr 17, 2012 at 23:31

Jay

2,5796 gold badges26 silver badges43 bronze badges

Collectives™ on Stack Overflow

MYSQL Syntax - Insert statement

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related