PHP Database Challenge 2

Still in the 'emmellst_example' database: Pull all customers from "customers" table, find matching addresses from "addresses"

(See additional database information below)

(Extensions would include a way to edit customer info, edit address info, and add new addresses for a given customer)

Last nameFirst nameAddresses
PinkyJackHome:
940 Fardon Way		Home:
145 Harvey Street		Cottage:
283 Corkery Woods Drive		Cottage:
541 Fox Valley Road		Villa:
548 Kathleen Crescent		Farm:
952 Harvey Street		Lake:
39 Andrew Street		Work:
283 Chipmunk Street
HamiltonsHelenCityHouse:
828 Dallaire Crescent		Villa:
30 Jeanne D'arc Boulevard		CityHouse:
11 Killeen Avenue		Work:
388 Issam Private		CityHouse:
228 Andrew Street		Home:
422 Century Road East		Work:
104 Perrywood Lane		Lake:
615 Corkery Woods Drive		Home:
901 Sonesta Circle		Work:
392 Orchard Hollow Drive		Work:
314 Dallaire Crescent
DelosLucasLake:
788 Perrywood Lane		Cottage:
49 Beechfern Drive		Villa:
799 Rideau Heights Drive		Home:
321 Bottriell Way		Lake:
651 Earl Mulligan Drive		Villa:
302 Dallaire Crescent		Work:
400 Indian Creek Road		Home:
755 Ottawa River Parkway
HolmesAzazHome:
417 Berot Lane		Cottage:
427 Kathleen Crescent		CityHouse:
89 Hiram Wilson Street		Villa:
216 Perrywood Lane		Home:
219 Sonesta Circle		Home:
800 Caldwell Avenue		Work:
690 Tierney Drive		CityHouse:
414 Fireside Crescent		Cottage:
264 10th Line Road		Home:
289 Garfield Avenue
AshbyEthanLake:
937 Cohen Avenue		Cottage:
172 Earl Mulligan Drive		Lake:
608 10th Line Road		CityHouse:
18 Timber Lane		Villa:
549 Fox Valley Road		Work:
662 Bottriell Way
BeeblebroxZaphodHome:
874 Baneberry Crescent		Work:
413 Harvey Street		Lake:
724 Earl Mulligan Drive		Work:
36 Andrew Street		Farm:
820 Killeen Avenue
SmithElaHome:
344 Garfield Avenue		Work:
80 Fireside Crescent		CityHouse:
817 Evangeline Street		Cottage:
727 Parkland Court		Villa:
121 Brouillette Boulevard		Villa:
462 Century Road East		Home:
399 Denali Way		CityHouse:
794 Saulnier Lane		Farm:
251 Queensdale Avenue		Farm:
503 Old Wellington Street
TrumpetJoshuaCottage:
251 Haanel Drive		Work:
831 Regal Crescent		Home:
418 Akenhead Crescent		CityHouse:
58 Acton Street		Farm:
471 Heritage Court		Work:
609 Chipmunk Street		Farm:
884 Evangeline Street		Lake:
393 Queensdale Avenue		Work:
683 Rideau Heights Drive
AndersonMaseyHome:
439 Perrywood Lane		Home:
748 Timber Lane		Home:
481 Brouillette Boulevard		Lake:
413 Rideau Heights Drive		Cottage:
413 Perth Street		CityHouse:
221 Century Road East		Home:
466 Rosebery Avenue		Farm:
82 Fireside Crescent		Work:
617 Tierney Drive		Villa:
961 Rideau Heights Drive		Work:
399 Perrywood Lane		Home:
58 Elliot Avenue		Villa:
165 Kathleen Crescent		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet
DentArthurHome:
684 Issam Private		Work:
271 Glenbrook Place		Farm:
911 Old Wellington Street		Cottage:
522 10th Line Road		Villa:
34 Berot Lane		Work:
163 Ottawa River Parkway		Lake:
762 Beechfern Drive		CityHouse:
215 Fox Valley Road		Cottage:
441 Dowler Avenue		Lake:
501 Abbey Road
ScottMichaelWork:
304 Elliot Avenue		CityHouse:
183 Berot Lane		Home:
926 Akenhead Crescent		Lake:
256 Timber Lane		Farm:
469 Elliot Avenue
HawkTonyVilla:
853 Berot Lane		CityHouse:
696 Spruce Ridge Road		Villa:
918 Perrywood Lane		Villa:
194 Brouillette Boulevard		Lake:
481 Heritage Court		Home:
199 Caldwell Avenue		Home:
387 Rosebery Avenue		CityHouse:
28 Chipmunk Street		Lake:
992 Harvey Street		Villa:
910 Kathleen Crescent		Cottage:
192 Caldwell Avenue
PicketDavisVilla:
966 Sonesta Circle		Home:
335 Chipmunk Street		Work:
809 Akenhead Crescent		Home:
314 Timber Lane		CityHouse:
957 Austin Court
BannerBruceLake:
967 Elliot Avenue		Cottage:
22 Akenhead Crescent		Lake:
872 Timber Lane		Work:
499 Old Wellington Street		Villa:
283 Chipmunk Street		Lake:
757 Caldwell Avenue		Farm:
597 Severn Avenue		Villa:
328 Singleton Way		Villa:
458 Abbott Street East		Villa:
770 Berot Lane
HickmansJohnCottage:
424 Ottawa River Parkway		Home:
663 Sonesta Circle		Work:
113 Indian Creek Road		Cottage:
366 Fardon Way		Work:
384 Hiram Wilson Street		CityHouse:
968 Garfield Avenue		Farm:
351 Fardon Way		Villa:
700 Perth Street		CityHouse:
213 Baneberry Crescent		CityHouse:
103 Abbott Street East		Farm:
67 Bayshore Drive		CityHouse:
634 Fardon Way
GyetkoDanteLake:
493 Sonesta Circle		CityHouse:
993 Regal Crescent		Villa:
929 Earl Mulligan Drive		Villa:
258 Dufferin Road		Farm:
38 Regal Crescent		Farm:
523 Parkland Court		Villa:
8 Jeanne D'arc Boulevard		Cottage:
997 Earl Mulligan Drive
AjerschAlexFarm:
725 Austin Court		CityHouse:
658 Timber Lane		Home:
974 Tierney Drive		Farm:
921 Timber Lane		Lake:
593 Timber Lane		Cottage:
386 Abbott Street East		Villa:
679 Allison Avenue		Villa:
999 Dufferin Road		Work:
892 Sonesta Circle		xxx:
33333 ssss		xxx:
33333 ssss		xxx:
33333 ssss		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet		TestDescription:
33333 TestStreet
WillowbeePutnumCottage:
763 Queensdale Avenue		Villa:
945 Blazer Avenue		Lake:
61 Bayshore Drive		Farm:
306 10th Line Road		Farm:
152 Bottriell Way		Lake:
792 Harvey Street		Villa:
156 Harvey Street		Home:
655 Baneberry Crescent		CityHouse:
272 Graham Creek Private		Cottage:
173 Portage Avenue		Work:
383 Evangeline Street		CityHouse:
742 Jeanne D'arc Boulevard		Lake:
547 Spruce Ridge Road		Cottage:
92 Graham Creek Private
CrosbieSammyFarm:
762 Corkery Woods Drive		Home:
16 Aldercrest Drive		Lake:
780 Perrywood Lane		Cottage:
515 Corkery Woods Drive		CityHouse:
680 Harvey Street		Farm:
715 Rideau Heights Drive
MooreIsaacLake:
867 Heritage Court		Villa:
889 Hiram Wilson Street		CityHouse:
488 Fireside Crescent		Villa:
208 Ottawa River Parkway		Cottage:
664 Jeanne D'arc Boulevard
MooreAmeliaCottage:
935 Jeanne D'arc Boulevard		Lake:
225 Portage Avenue		Farm:
749 Glenbrook Place		Home:
89 Rosebery Avenue		CityHouse:
117 Jeanne D'arc Boulevard		Work:
264 Haanel Drive		Cottage:
793 Berot Lane		Villa:
440 Brewer Way		Work:
664 Graham Creek Private		Villa:
808 Dufferin Road
BlackJackVilla:
367 Brouillette Boulevard		Farm:
459 Earl Mulligan Drive		CityHouse:
995 Abbey Road		Farm:
780 Fox Valley Road		Villa:
410 Acton Street		Cottage:
633 Beechfern Drive		Cottage:
224 Tierney Drive		Work:
93 Dowler Avenue		Kickapoo:
67 Tenacious D St		Kickapoo:
67 Tenacious D St		Kickapoo:
67 Tenacious D St		Kickapoo:
67 Tenacious D St		City:
67 Street 67		City:
67 Street 67		City:
67 Street 67
DowdallJaneCityHouse:
610 Killeen Avenue		Home:
883 Fardon Way		Farm:
819 Andrew Street		Work:
243 Caldwell Avenue		Cottage:
764 Sonesta Circle		Work:
549 Dufferin Road		Farm:
440 Severn Avenue
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJackHoliday:
21 Broken Dreams Blvd
BlackJack
BlackJack
BlackJackHoliday:
21 Broken Dreams Blvd
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack
BlackJack


Do not reproduce this part

'customers' table               'addresses' table
+------------+--------------+   +-------------+-----------------+
| Field      | Type         |   | Field       | Type            |
+------------+--------------+   +-------------+-----------------+
| cust_id    | int          |   | addr_id     | int             |
| cust_lname | varchar(255) |   | addr_cust   | int             |   //THIS IS THE ID OF THE CUSTOMER WHO THE ADDRESS BELONGS TO
| cust_fname | varchar(255) |   | addr_desc   | varchar(128)    |
+------------+--------------+   | addr_number | varchar(32)     |
                                | addr_street | varchar(128)    |
                                | addr_city   | varchar(64)     |
                                | addr_prov   | enum (provCode)Any value from this list:
'AB','BC','MB','NB','NL','NS',
'NT','NU','ON','PE','QC','SK','YK' |
                                | addr_postal | varchar(16)     |
                                +-------------+-----------------+