How do I filter out items? Should be simple?

[loren646]

I am using two tables.

 

"Landlord Table" is a 2 column table. column 1 = "Landlord name" and column 2 ="buildings". "buildings" are set as a primary key.

 

All data from this table is displayed under "Landlord Table" on bottom of page at:

 

http://responsiblyvodka.com/tester.php

 

 

Problem: I want to add available apartments into a NEW table for potential renters. Instead of searching through all the buildings like I currently have at top in the second combobox. I want to click the landlord name i.e. "ABC" and only have 3 building addresses show up in the combo next to it.

[fenway]

MySQL doesn't know about clicks -- what are you actually trying to achieve?

[Barand]

You said you are using two tables but then only mention landlord table.

 

Can you give us the structure of these tables and some sample data?