I need to be able to search for cars from a database dependent on price when a user selects a certain price bracket.
I have something like this but I don’t think its right.
$query = "SELECT * FROM cars
WHERE price >= '%".$lower."%' && price <= '%".$higher."%' ORDER BY make";
All l need is a query that selects, for example, all cars that cost from £100 to £150.
Any help much appreciated.