|
|
Posted by news.tpg.com.au on 10/04/45 11:17
It's sorting by the text value rather than the number.
If you search between 0 and 1,000,000 it will only find results starting
between 0 and 1. You'll notice that a search up to 700,000 will result in a
2 bedroom townhouse for 69,950.
I believe there is a function called between() that could be worth looking
into.
Alternatively use strlen() to count the numbers in the price (i.e. 6 for
anything in the 100,000s) and then use left() to find the first number for
sorting purposes. A little more work but suitable if you're only searching
by the 100,000s.
Careful with the < / <= 1,000,000 - using <= 999,999 might be easier for
you.
It's also probably a good idea to always place the field name on the left of
an operator as it works from right to left
i.e. price >= 'pricefrom' AND price <='priceto'
Hope that helped.
"chris" <c.delgado@ntlworld.com> wrote in message
news:DR2ne.7340$rf4.5558@newsfe5-win.ntli.net...
> 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]
|