Displaying Price Range Options
On my page I am trying to create a list of values that a customer can choose between so that they can filter records from the Recordset based upon a price range such as:
Up to £500
Up to £700
Up to £900
Up to £1500
Up to £2500
I can get this to work using the SQL statement
SELECT * FROM content WHERE Price > 0 AND Price < 500
This works fine but I'm sure there's a better way of doing it rather than creating 5 different recordsets, one for each price range.