Limit range of query

[ow-phil]

Hi All,

I am working on a fairly simple search which is for looking for products within a certain price range. What I would like to know is how do I search the same category "price" so that it knows to select everything that price is greater than the low range "$lowprice" and less than the high range "$highprice".

I was thinking something like:

SELECT * FROM inventory WHERE type='$type' AND price>'$lowprice' AND price<'$highprice'

[stolzyboy]

SELECT * FROM inventory WHERE type='$type' AND price BETWEEN '$lowprice' AND '$highprice'