GoFuckYourself.com - Adult Webmaster Forum - What type of MYSQL JOIN do I need

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - What type of MYSQL JOIN do I need (https://gfy.com/showthread.php?t=1050145)

What type of MYSQL JOIN do I need

My old query was:

Code:

$query = "SELECT city_name FROM city WHERE province_id = 9";

Now I'm using:

$city = $_GET['city'];

and just have the city name now but need to fetch all the cities in the province that $city is in.

Here are my tables:

Code:

Table: city

column: city_name = Vancouver, Victoria, Edmonton

column: province_id = 9, 9, 8



Table: province

column: id = 8, 9

column: name = Calgary, British Columbia

So if $city is in province British Columbia, what type of join to I need to fetch all cities listed in British Columbia?

SELECT city_name FROM city WHERE province_id IN (SELECT province_id FROM city WHERE city_name = $city) ???

If you ever need major coding help contact me anytime!