I m making a real estate website where i can display all the available properties for sale, renting and etc.
So created using dataassist where all the data is stored in database & retrieved on the result pages..
So i need help in filtering. I kinda find it little difficult to do this.
If possible please help me in detail.
I got 1 DB & in that there are 3tables..
*table1 is Properties which contains name of builder/company name, building/property name, locations,min max price, imgs etcetc..
*table2 is builderslist which contains list of builders name
*table3 is locations list which contains List of locations
while inserting record ie. properties, the builder name is taken from table1 (buildername) and location from locationlist table2 from DB..
So now lets say a user is checking a property of "X" company in property_details page. So now i want a to show users other properties of same builder in that page may be like 1 or more properties..
All required files are attached..