Hi, I seem to be having a problem trying to insert the data on page 167 into the table, using the books example. The final code is supposed to look like this:

 INSERT INTO
 'movie'
 ('movie_name', 'movie_type', 'movie_year')
VALUES
 ('Bruce Almighty', '1', '2003')

When I click go button to execute I get this message

  MySQL said: Documentation
#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 ''movie'
('movie_name', 'movie_type', 'movie_year')
VALUES
('Bruce Almighty'' at line 2

If anyone knows what the problem is... or how to work around this I would really appreciate it..

Thank You

Did you create the (movie) table yet? That has to exist first.

 Yeah I did. I copied the chapter6 mysql code that was created and put up on this forum.. I named the database Wiley. In the Database Wiley it contained the movie table. When I copied and pasted the Database code for the Wiley Database in myphpadmin it worked. I just couldn't Insert any Data afterwards. I even made another Database called Test and created a movie table that included movie_name movie_type movie_year. I kept all the fields empty (Data wise) and I still couldn't Insert anything into those fields without getting the same errors.... :-(

Anyone know whats up? myPhpAdmin is the newest stable release, as well as the PHP and MySql. Everything seems to be set with the right settings accordingly and was programming well up until the myPhpAdmin parts in chapter 6.

-Thank You