I seem to be having a phpmyadmin problem.. Can some one please try this out on your phpmyadmin and see if it works...

* please make a database and a table named movie, and create these 3 fields movie_name movie_type and movie_year.

Then type this is in your phpmyadmin and see if it works

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

If it does work, please let me know what version of MySQL and phpmyadmin you are currently using.. Because I can't seem to get mine to work without getting an error.

- Thank You

1 what is the error?
2 what are the data types of the fields?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

1) The error

Error

SQL query:

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

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

2) Data type

CREATE TABLE `movie` (
`movie_id` int(11) NOT NULL auto_increment,
`movie_name` varchar(255) NOT NULL default '',
`movie_type` tinyint(2) NOT NULL default '0',
`movie_year` int(4) NOT NULL default '0',

Please let me know if you find anything... thank you for your time.

-TheDudeTux

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

That should fix your problem let me know.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hey Dparsons it worked!! Thanks a lot man. But, I still don't understand why the original way didn't work? I was following the example in the book.. which included the semi quotes ' ' Is this an error in the book? Or is this a configuration problem on my end? Thanks again, I been delayed for a couple days cause of this.

- Thank You

p.s. do you use phpmyadmin or something else?

You syntax was incorrect because you were using ' as opposed to ` When you surrounded the table name and column names with ' ' you turned them into string literals and mysql didnt understand which table and columns you were trying to insert into.

I have not used MySQL in a few years but when I did, I used Query Browser and MySQL Administrator

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

 Hey Dparsons... Thanks a lot for helping me out on this. I get what you were saying. Now I can move on with these chapters, thanks again.
 -TheDudeTux