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: 2 TURTLE_STREETCottagee: 42 turt_st home: 70 buttadjklsa: 2324 ASjdllkParis France: 72312 PSGTesting123: 4234 asdasd home: 16 Lismer Crescentjjjjjjj: 56 stjjjjjjj: 56 st
HamiltonsHelencottage: 2589 t: t t
DelosLucasHome: 206 Hitchhikers_WayHOME: 7-0 unitedHOME: 7-0 unitedHOME: 7-0 united
HolmesAzazHome: 11 Fifth_AveHello: 342 Hello 45stHello: 342 Hello 45st
AshbyEthanCottage: 24601 Newbie_Sthomed: 124 phphpmongolia: 737-1111 f'(x)=7xASD: ASD SD
BeeblebroxZaphodCottage: 12 mellow_stWork: 31 Street St.lkjhgkjghkj: 42 hitchhiker's wayfgbsfg: wgwr dgfhfdg: vcxbs dfsadf
SmithElaHome: 113 Artist_RdCottage: 113 Artist_Rdskdhsajkhdjksa: sadlmsanm,d asd,mn
TrumpetJoshuaWork: 123 Worker_StWork: 123 Worker_StWOAH: 928 Kingsview CourtWOAH: 928 Kingsview CourtWork: 123 Worker_St
AndersonMaseyEscape: 22 Jumpstreettest: 42 Test Sttest: 42 Test StThisisatest: 3424 Westcarletondsa: 12 fswed: d dd: d dhome: 2222 ron
DentArthurThisDescript: 61345 Testing3432Home: 42 Hitchhiker Rd.STADIUM: 4-1 CAMP NOUhere: w where: w wCottage: 1 Giorgina Stdiznov: 89u43896 lkknesf
ScottMichaelCottage: 1 TEst-StHome: 1234 Dove
HawkTonyHome: 234 Amanda Sthome: 21 skate boardmongolia: e eqq: qq qqq
PicketDavisSchool: 3088 Dunrobin Rd.Home: 23 Oakville Drive
BannerBruceWork: 1 Cave_Parkhome: 239057 brickHome Cot: 696900 333
HickmansJohnCottage: 12 TestCottage: 12 Test
GyetkoDanteHome: 1337 Foobar_RdDumg: Mine Stat
AjerschAlexdesc: 0 stdsfsd: 3423 saddsfsd: 3423 saddes: 123 22des: 123 22Home: 123 March Roaddes: 123 22test: test testtest: test testtest: test testtest: 213123 123123test: 213123 123123yil: test: 5067 mongoliatest2: 5067 Queent: 45 0405test2: 5067 QueenNo: 2 MineNo: 2 MineHi Mr emmell: 6262 Weird that I'm here :)temp: 2 v2: q: q qhome: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666home: 666 666 666: : : : : : :
WillowbeePutnumwad: e435 awdga
CrosbieSammyHot: 1568 Old Brooke RoadHot: 1568 Old Brooke RoadNo: 2 Mine
MooreIsaacBIG HOUSE: 321 tree ave.
MooreAmelia


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)     |
                                +-------------+-----------------+