MikeMikeMike Posted April 18, 2011 Share Posted April 18, 2011 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'); Link to comment Share on other sites More sharing options...
Larry Posted April 18, 2011 Share Posted April 18, 2011 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. Link to comment Share on other sites More sharing options...
Recommended Posts