asked on Populate dropdown menu with unique column entries
For my real estate site I have two databases, one called 'Country' which lists all countries and their codes and another 'properties' which has all of the properties details. The properties table uses the country code from the 'Country' table (countrycode column) to state which country the property is from.
I need to create search function which just has a dropdown where you select a country. What query would I use to show a list of country names from the 'Country' table if the country code appears in the 'countrycode' column of the 'properties' table. Also each country should only display once. So the dropdown should show 2 options - United Kingdom and Turkey.
Screen-shot-2012-03-13-at-16.10..png
Screen-shot-2012-03-13-at-17.10..png
I need to create search function which just has a dropdown where you select a country. What query would I use to show a list of country names from the 'Country' table if the country code appears in the 'countrycode' column of the 'properties' table. Also each country should only display once. So the dropdown should show 2 options - United Kingdom and Turkey.
Screen-shot-2012-03-13-at-16.10..png
Screen-shot-2012-03-13-at-17.10..png
MySQL ServerPHP
Last Comment
BrighteyesDesign
ASKER
Thanks for that,
Would I then call the results using <?php echo $query_countries['properti
$query_countries = "SELECT DISTINCT country.name,country.code FROM properties LEFT JOIN country ON country.code = properties.country_code"
?>
Would I then call the results using <?php echo $query_countries['properti
ASKER
Also, using...
...gives an error of "Unknown column 'country.name' in 'field list'"
Just to recap...
I have on table called 'Country' which has the column 'Code' and 'Name'
Then I have another table called 'properties' which has a column called 'country_code'
I need to display the name of the country (from Country table » Name column) if the country code is in the properties table 'country_code' column.
Then display all of these country names as a list (only once each).
SELECT DISTINCT country.name,country.code FROM properties LEFT JOIN Country ON country.code = properties.country_code
...gives an error of "Unknown column 'country.name' in 'field list'"
Just to recap...
I have on table called 'Country' which has the column 'Code' and 'Name'
Then I have another table called 'properties' which has a column called 'country_code'
I need to display the name of the country (from Country table » Name column) if the country code is in the properties table 'country_code' column.
Then display all of these country names as a list (only once each).
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect, thanks for that
Open in new window
HTH