Sql To Insert Into Stores Table Not Working For Me

[MikeMikeMike]

I'm on page 99 of Advanced PHP 5. I was able to enter the U.S. zip code file into zips database following Larry's instructions. I then crated the "stores" table successfully. Larry then suggestst that we enter

some sample data into the stores table, so I downloaded the sql (see below) from his website.

 

However, after I copied and pasted it into the command line, all it did was respond with

'>

. In other words, it did nothing. I checked the database through phpmyadmin and stores is empty

 

You can see from the image on my command line that about half way down the arrows

->

changed to

'>

. I don't know if that means anything.

 

 

 

Any ideas what might be going wrong?

 

 

 

 

INSERT INTO stores (name, address1, address2, zip_code, phone) VALUES 
(‘Ray''s Shop', ‘49 Main Street', NULL, ‘63939', ‘(123) 456-7890'), 
(‘Little Lulu''s', ‘12904 Rockville Pike', ‘#310', ‘10580', ‘(123) 654- 7890'), 
(‘The Store Store', ‘8200 Leesburg Pike', NULL, ‘02461', ‘(123) 456- 8989'), 
(‘Smart Shop', ‘9 Commercial Way', NULL, ‘02141', ‘(123) 555-7890'), 
(‘Megastore', ‘34 Suburban View', NULL, ‘31066', ‘(555) 456-7890'), 
(‘Chain Chain Chain', ‘8th & Eastwood', NULL, ‘80726', ‘(123) 808-7890'), 
(‘Kiosk', ‘St. Charles Towncenter', ‘3890 Crain Highway', ‘63384', ‘(123) 888-4444'), 
(‘Another Place', ‘1600 Pennsylvania Avenue', NULL, ‘05491', ‘(111) 456- 7890'), 
(‘Fishmonger''s Heaven', ‘Pier 9', NULL, ‘53571', ‘(123) 000-7890'), 
(‘Hoo New', ‘576b Little River Turnpike', NULL, ‘08098', ‘(123) 456-0000'), 
(‘Vamps ‘'R'' Us', ‘Our Location', ‘Atwood Mall', ‘02062', ‘(222) 456- 7890'), 
(‘Five and Dime', ‘9 Constitution Avenue', NULL, ‘73503', ‘(123) 446- 7890'), 
(‘A & P', ‘890 North Broadway', NULL, ‘85329', ‘(123) 456-2323'), 
(‘Spend Money Here', ‘1209 Columbia Pike', NULL, ‘10583', ‘(321) 456- 7890');

[Larry]

It looks like the SQL file got corrupted somehow. Sorry about that. I just uploaded a fresh version of the scripts. Let me know if you continue to have problems with it.