Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0
This is the forum to discuss the Wrox book Beginning PHP5, Apache, and MySQL Web Development by Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz, Michael K. Glass; ISBN: 9780764579660
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 20th, 2007, 04:59 AM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch 6 Page 167 (PhpMyAdmin)

 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

Reply With Quote
  #2 (permalink)  
Old March 20th, 2007, 12:14 PM
Authorized User
 
Join Date: Jul 2006
Location: Happaugh, NY, .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #3 (permalink)  
Old March 20th, 2007, 02:11 PM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by tbrown
 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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch. 6 Try it out Page 187 mcauliff BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 4 November 4th, 2007 03:58 PM
Page 975; Ch 19 Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 0 July 31st, 2006 12:25 AM
Please help with Chapter 3 - Using PHPMyAdmin nooten1 BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 March 18th, 2006 03:24 PM
CH 5 Page 153 zamankazi BOOK: ASP.NET Website Programming Problem-Design-Solution 8 November 4th, 2004 08:38 AM



All times are GMT -4. The time now is 03:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.