A Query Problem

[AvisSoft]

hello

i have 4 fields

1. category
2. from_price
3. to_price
4. words

this is basically a search query ...i don't know how to query for range like a user need to search like:

category : visual basic
from_price: 10
to_price: 100
words: active x controls

now active x controls should be displayed which are in range from 10 to 100 in the category visual basic. ( i will make the display thing) please help me with query.

thanks!

[ober0330]

SELECT * FROM tablexyz WHERE category = 'visual basic' AND range BETWEEN 10 AND 100

Hopefully you don't have 2 fields in the database. Unless you're actually storing ranges, you should only store the price for the item and use the BETWEEN keyword to search for things in a certain range.

[AvisSoft]

Hi Ober,

Thanks for the reply. Yes i am only stroring price. Also you did not mention the keywords in the query how do i search for keywords ?

Thanks!

[ober0330]

Oh, sorry. Forgot that part:

SELECT * FROM tablexyz WHERE category = 'visual basic' AND range BETWEEN 10 AND 100 AND words LIKE '%active x controls%'

[AvisSoft]

Thanks ober u r gr8 m8!