Hello, a need help with this php file, first i using try out 2 for the files movie.php and commit.php, the problem appears when i add a new movie i fill all fields and allways show me the error 'please enter a movie name', i don't know why i'm trying to solve but i can't and i think that the code is correct:

               $movie_name = trim($row[ 'movie_name' ]);
               if( empty($movie_name)){
                  $error .= "Please+enter+a+movie+name%21%0D%0A";
               }
i delete the trim($row[]) keeping the the next sentence

               $movie_name = 'movie_name' ;
               if( empty($movie_name)){
                  $error .= "Please+enter+a+movie+name%21%0D%0A";
               }

and works perfect for commit.php try out 1 but for commit.php try out 2 show me the next error:

Invalid query: Column count doesn't match value count at row 1

waiting for help thx...

It should have been $_POST in stead of $row
$movie_name = trim($_POST[ 'movie_name' ]);

i did that before to solve the problem but show the next error:
Invalid query: Column count doesn't match value count at row 1

so i think the problem is in the moment of fill the database
 if ( empty($error) ){
                     $sql = "INSERT INTO
                              `movie`
                              ( `movie_name` ,
                                `movie_year` ,
                                `movie_release` ,
                                `movie_type` ,
                                `movie_leadactor` ,
                                `movie_director` ,
                                `movie_rating`)
                           VALUES
                              ( '".$_POST['movie_name']."' ,
                                '".$_POST['movie_year']."' ,
                                '$movie_release'
                                '".$_POST['movie_type']."' ,
                                '".$_POST['movie_leadactor']."' ,
                                '".$_POST['movie_director']."',
                                '$movie_rating' )
                           ";
and i don't why in $movie_release at the and dom't finish with a ','
i put it and all works perfect...

however thx for reply...