|
|
Posted by chris on 10/01/59 11:17
I have put together an online estate agent but the search results are coming
back wrong it will retrieve the correct results if you search with the lower
at 0 and the greater price at 1,000,000 but if you search from 1 to 600,000
or any combinations it only brings back one result I cant understand it,
this is in terrace/town house, bedrooms 1. but the others seem to work ok
ie: semi detached.
My query is
SELECT *
FROM properties
WHERE county = 'colname' AND property_type = 'property' AND no_of_bedrooms
>= 'bedrooms' AND 'pricefrom' <= price AND 'priceto' >= price
the page is http://www.kwiksale.co.uk/england.php
Can anyone help?
Thanks
Navigation:
[Reply to this message]
|