So I have two tables: 1) Landlords 2) Properties
Landlords stores all the landlords and the properties stores all the landlords properties and has a primary/foreign key respectively of landlord_id to link them.
There are two queries one to just load all landlords and one to load the properties based on the landlord_id found in query 1 (load landlords)
I have nested loops one for all the landlords, and the other for all the properies each landlord can have.
The landlords loop, brings in all the landlords perfectly well.
But the properties loop only loads the properties for the first record only.
I am using php and mysql. Not sure what is going on.
Any help would be appricated.