title: PHP: How to make a list of film and genre (example) - MySQL Join Many-to-Many (want?) and the PHP?
body: <p>How to make a list of film and genre - MySQL Join Many-to-Many (should I?) And the PHP?
  Or do the other way?</p>
  
  <p><strong>Examples:</strong><br/>
  In MySQL:</p>
  
  <pre><code>Table 1:
  movie_id | movie_title
  1______  | title_movie_1
  2______  | title_movie_2
  3______  | title_movie_3
  
  Table 2:
  genre_id | genre_title
  1______  | title_genre_1
  2______  | title_genre_2
  3______  | title_genre_3
  
  Table 3:
  id | movie_id | genre_1
  1_ | __1____ | _1
  2_ | __1____ | _2
  3_ | __2____ | _1
  4_ | __2____ | _3
  5_ | __3____ | _1
  6_ | __3____ | _3
  7_ | __3____ | _2
  </code></pre>
  
  <p><strong><em>Results PHP:</em></strong></p>
  
  <pre><code>Movie: &lt;a href="movie/1 (id_movie)"&gt;title_movie_1 _/a&gt;
  Genre: 
  &lt;a href="genre/1 (id_genre)"&gt;title_genre_1 _/a&gt;, 
  &lt;a href="genre/2"&gt;title_genre_2 _/a&gt;
  
  Movie: &lt;a href="movie/2 (id_movie)"&gt;title_movie_2 _/a&gt;
  Genre: 
  &lt;a href="genre/1"&gt;title_genre_1 _/a&gt;,
  &lt;a href="genre/3"&gt;title_genre_3 _/a&gt;
  
  Movie: &lt;a href="movie/3 (id_movie)"&gt;title_movie_3 _/a&gt;
  Genre: 
  &lt;a href="genre/1"&gt;title_genre_1 _/a&gt;
  &lt;a href="genre/2"&gt;title_genre_2 _/a&gt;
  &lt;a href="genre/3"&gt;title_genre_3 _/a&gt;
  </code></pre>
  
  <p>I can not find do ...
  Help, please! I'm waiting!</p>
  
  <p>Sincerely, Areku</p>