Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 20th, 2007, 04:59 AM
Authorized User
 
Join Date: Feb 2006
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

 
Old March 20th, 2007, 12:14 PM
Authorized User
 
Join Date: Jul 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old March 20th, 2007, 02:11 PM
Authorized User
 
Join Date: Feb 2006
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






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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.