MySQL Forums
Forum List  »  PHP

Re: echo names from multiple tables
Posted by: Barry Galbraith
Date: February 13, 2012 06:07PM

I think something like this.

Table bands
Table events
Table types

Events then has a field linked to bands, and a field linked to types

You could then have a band performing multiple types at the one event.
You can have multiple bands performing at one event.
And so on.

Display then becomes SELECT .. WHERE type = .. AND event = ..

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: echo names from multiple tables
February 13, 2012 06:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.