You're missing the field name in the second comparison -
Code:
SELECT * FROM store WHERE searchPrice >= 50 AND <= 100 ORDER BY searchPrice ASC
Should be
Code:
SELECT * FROM store WHERE searchPrice >= 50 AND searchPrice <= 100 ORDER BY searchPrice ASC
__________________
Those who can do, those who can't talk about it
|