Help with JavaScript and MySQL


I have these two MySQL tables (location, properties). Each location can have one or more properties so both tables are related using Keys.

What I’m trying to implement is an HTML form where when a user selects a location then the system automatically filters the properties results accordingly.

The “location” list is loaded from MySQL using PHP, but obviously PHP doesn’t allow me to filter the “properties” list while the selection is at the user side.

I thought that this may be done using JavaScript? I don’t know JavaScript so any help would be greatly appreciated.