I need help for database modeling and query. I am makeing sport statistic site and have no idea how to make Head-to-head section. I have two tables in mysql database. One with players (ID, name, country....) Second with matches between players (ID, player 1, score 1, player 2, score 2, tournament, season....). I need to have two dynamic drop-down menus with players. User have to select from them two players, click on Button and see query abut matches between selected two players. I suppose, that need to have third table and make many-to-many relationship, but not sure. I need ideas, please!

My detailed question:

I have 3 tables:
1. players (player_id, player, country, dob.....)
2. matches (matches_id, player1, score1, player2, score2, tournament, season....)
3. playerMatches (player_id, matches_id)

I have many-to-many relationship. I need to query all matches between whoever two selected from user players.
That is my question? Thanks!

I'd suggest you hire a database Designer/Administrator with any luck they will be able to get ALL the information necessary to give you a useful answer.

As it stands the best I can offer is: Use a JOIN query of one sort or another.