So this is my script that i got someone to install and it has some movies on there as well. I just need someone that i well aware of this script and can help me out with it. One this is that i get this error everytime i try to go to the second page of the editing for my movies. "Database error: Invalid SQL: select C_Title from tbl_movie where PK_MovieID = MySQL Error: 1064 (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 '' at line 1) Session halted." Thanks
It's hard to understand what could be going wrong based on provided information. I guess that could be an error in the mysql statement or some invalid characters. The sql script is concatenated, so it's not enough to determine what could be wrong. Do you know what function you are calling? Full sql statement from the code could be helpful too?
We can only guess without seeing the entire query, and that might not even be enough. My guess is that PK_MovieID variable is missing or maybe you have one too many (or one too few) single quotes ' in the statement.