Make an app like this one.
Create two more tables in your wombat DB.
The games table shows games. Here's my definition of it. It just has an id and a name.
Create another table to represent a many-to-many relationship between games and wombats. Each wombat can play many (or no) games, and one game can be played by many (or no) wombats. I named the table plays
, but you can call it something else. Here's my definition.
Put some test data in your new tables.
Here are the files I created for the app:
You don't have to use this structure.
There are four pages. First, a page to show a list of wombats.
Click a link, and see the deets for that wombat, including a list of the games that wombat plays:
If a wombat plays no games, show a message to that effect.
Click on a game name, and see the deets for that game, including a list of the wombats who play that game:
If no wombats play the games, show a message to that effect.
There should also be a page to show a list of games.
Click on a link to see the deets for that game.
Submit the URL of your solution, and a zip of your files. The usual coding standards apply.