Filtering Help

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..

Thank You

create another recordset to query the property table. you'll need to use advanced view.

SELECT * FROM Properties where NameofBuilder = paramBuilder

in the paramters section, create a new parameter as:
name: paramBuilder
type: text
default value: -1
run time value: $row_WADAresidentials['NameofBuilder']

Ok that was awesome.. What if i want to show 2 or more properties then?

use a repeat region.

Ok thats great..

But what about Hyperlink to give it to them? when i clicked on the name i want to take them to that particular property(detail) page.

<a href="?"> <?php echo $row_Recordset1['NameofProperty']; ?> </a>

BuildingID
<a href="Prop_Detail.php?BuildingID=<?php echo $row_Recordset1['NameofProperty']; ?>"> <?php echo $row_Recordset1['BuildingID']; ?> </a>

By the way by adding recordset and using SELECT * FROM Properties where NameofBuilder = paramBuilder


It shows the 1st record from Property of NameofBuilder.

How to get random of property name from NameofBuilder?

add:
ORDER BY RAND()

to the recordset

Cool..

Thanks a lot.

This post has been deleted.