PHP MySQL Joining Tables

Question

I'm trying to create a directory and I have two tables, entry and location. Each entry will be able to have multiple locations so I'm assuming the best idea (correct if wrong) is to create a third table where I specify 'links'. Example:

Marly:France
Karla:Argentina
Smith:USA
Katie:France
Smith:United Kingdom
Katie:USA

When I want to list people from France I'd go into that third table and pull up names where location = France. I'm fine with doing everything up to this point, but now I need to retrieve data from the entry table for each Name of each person in France (according to the third table). I'm pretty sure I've seen this done before. Any pointers? :D

Answer 1

SELECT `entry`.*
FROM `entry`
JOIN `entry-locations` ON `entry-locations`.`entry-id` = `entry`.`name`
WHERE `entry-locations`.`location` = 'Aberdeen'

$res = mysql_query('all-that-stuff-above');
while($row = mysql_fetch_assoc($res)) {
    echo $row['name'] . "\n";
}
mysql_free_result($res);

Answer 2

SELECT
    entryt.name AS name,
    locationt.location AS location
FROM locationt, entryt
WHERE locationt.location = "France"

Remember: Change the names I used there:

• I named the entry table as "entryt"
• And the location table as "locationt"

Should return "name" with all the people that live in France.

Pretty sure that would work. Still, correct me if I'm wrong.

Answer 3

SELECT * FROM entry WHERE name in (SELECT name FROM links WHERE location = 'FRANCE');

I have assumed the table names as 'entry' & 'links' and column names as 'entry.name' and 'links.location'.