|
|
Posted by chris on 10/05/59 11:17
Thanks very much for the speedy response. We will have a play with the
between function. Also, just noticed that I had set the column in the db to
varchar
"news.tpg.com.au" <carol500@tpg.com.au> wrote in message
news:429ccf8c$1@dnews.tpgi.com.au...
> 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]
|