I'm trying to build a query to filter car makes, models and trims based on price ranges.
My table name is "TblVersoes" and my price field is called "Euros"
So, I have 4 price ranges:
1 -> TblVersoes.Euros >= 15000 AND TblVersoes.Euros < 25000
2 -> TblVersoes.Euros >= 25000 AND TblVersoes.Euros < 35000
3 -> TblVersoes.Euros >= 35000 AND TblVersoes.Euros < 45000
4 -> TblVersoes.Euros >= 45000
The user will be able to select 1 or more prices.
For just one price it's easy.
But what if the user selects price range 1 and 4 or 2 and 3?
How should I build the query for those cases?
My DB is MSSQL and I'm building my webpage with PHP.
Thankx for any help,