Ive been working with php for a little while now and have just discovered the world of database normilization. whilst i totally understand how to structure my database conforming to 3NF im having trouble getting my head around the query i should be using to handle a many to many db relationship.
i have the following tables
i wrote a query originally like this
SELECT * FROM gigs,venues,gig_list,bands WHERE gigs.gig_id = 1 AND venues.venue_id = gigs.venue_id AND gig_list.gig_id = 1 AND bands.band_id = gig_list.band_id
which produced results but obv not right. i thought maybe i should be doing this in two quries but i just cant get my head around it. Any help is greatly appreciated