I'm trying to do a page of items between set prices and I either get an error or the search returns every item. This is what I've tried
Quote:
|
SELECT * FROM store WHERE searchPrice => 50 OR searchPrice <= 100 ORDER BY searchPrice ASC
|
Where
am I going wrong?