Search Form

Databases
1

Hello to you all

I have this query but I need some help on this:

$query = "SELECT distinct Img.propertyId as PropertyId, Title, ImageUrl, Location, Bedrooms, Bathrooms, Parking, Price FROM PROPERTIES as Prop LEFT JOIN IMAGES as Img ON Img.PropertyId = Prop.PropertyId WHERE 1=1 ";

I have a Price inside my table and on my search form I have a Min Price and a Max Price, how can I connect it to my Price so if someone search for instants Min Price: 1000 and Max Price 10000 it has to give the results between 1000 and 10000.

2

add this –

AND price BETWEEN 1000 AND 10000