Code: Select all
$query = "SELECT * FROM *MYTABLE* WHERE make='$make' AND model LIKE '%$model%' AND WHERE $year between madefrom AND madeto LIMIT $limitvalue, $limit";I have also tried changing the last bit to this but still had no luck gettign it to work
Code: Select all
WHERE $year between datepart(yy,madefrom) AND datepart(yy,madeto)Wardy