ch 6 commit.php problem updating movie table

statusquo · May 2nd, 2005, 04:12 PM

Hello everyone.

I made the changes to commit.php as shown on pg 186 of chapter 6, but I get a sql error when I try to edit a movie. The error message I get is : Invalid Query : 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 ''movie_name' = 'Test2', 'movie_year' = '2005', 'movie_type' = '

This is my query statement :

Code:

$sql = "UPDATE movie 
    SET 
        'movie_name' = '".$_POST['movie_name']."', 
        'movie_year' = '".$_POST['movie_year']."', 
        'movie_type' = '".$_POST['movie_type']."', 
        'movie_leadactor' = '".$_POST['movie_leadactor']."', 
        'movie_director' = '".$_POST['movie_director']."' 
    WHERE 
        'movie_id' = '".$_GET['id']."'";

I have been looking at this for hours and can't find the error... my eyes are tired

Any help would be appreciated. TIA

statusquo · May 2nd, 2005, 10:02 PM

I found the cause of the sql error.

fieldnames should have back ticks around them instead of single quotes. (the back tick is the key to the left of the 1 key in the upper left corner.... in case you were wondering). Single quotes are fine for the values....but back ticks for field names.

The corrected code looks like this :

Code:

$sql = "UPDATE 
        `movie` 
    SET 
        `movie_name` = '".$_POST['movie_name']."', 
        `movie_year` = '".$_POST['movie_year']."', 
        `movie_type` = '".$_POST['movie_type']."', 
        `movie_leadactor` = '".$_POST['movie_leadactor']."', 
        `movie_director` = '".$_POST['movie_director']."' 
    WHERE 
        `movie_id` = ".$_GET['id'];

They look similar, but can be the difference between an updated table and a sql error.

Hope this helps someone.