Code: Select all
$result = mysql_query ("SELECT * FROM dxvehicles WHERE make = '$make' AND title LIKE '%$model%' AND motability = '$motability' AND stockstatus = 'in stock' AND scrappage != 'scrappage' LIMIT $offset, $rowsPerPage") or die (mysql_error());I am also passing pricemin and pricemax through to this page. So basically I need to do something like this:
Code: Select all
SELECT * FROM dxvehicles WHERE price <= pricemax AND price >= priceminI have only ever done this in an IF statement after the query, but am sure there is a 'query' way of doing it.