HELP! MySQL Join Many to Many + PHP

vimaxvimaxbbox

New Member
And how to write MySQL Join and PHP?
Or you can make another? ...Examples:Table 1:movie_id | movie_title1______ | title_movie_12______ | title_movie_23______ | title_movie_3Table 2:genre_id | genre_title1______ | title_genre_12______ | title_genre_23______ | title_genre_3Table 3:id | movie_id | genre_11_ | __1____ | _11_ | __1____ | _21_ | __2____ | _11_ | __2____ | _31_ | __3____ | _11_ | __3____ | _31_ | __3____ | _2Results PHP:Movie: title_movie_1Genre: _a href="http://stackoverflow.com/questions/3625564/genre/1 (id_genre)">title_genre_1 _/a>, _a href="http://stackoverflow.com/questions/3625564/genre/2">title_genre_2 _/a>Movie: title_movie_2Genre: _a href="http://stackoverflow.com/questions/3625564/genre/1">title_genre_1 _/a>,_a href="http://stackoverflow.com/questions/3625564/genre/3">title_genre_3 _/a>Movie: title_movie_3Genre: _a href="http://stackoverflow.com/questions/3625564/genre/1">title_genre_1 _/a>_a href="http://stackoverflow.com/questions/3625564/genre/2">title_genre_2 _/a>_a href="http://stackoverflow.com/questions/3625564/genre/3">title_genre_3 _/a>I can not find do ...
Help, please! I'm waiting!

Sincerely, Areku
 
Back
Top