Thread
:
Mysql search query
View Single Post
#
4
(
permalink
)
05-12-04
Melter
Registered User
Join Date: Aug 2003
Location: Cornwall
Posts: 209
Thanks: 0
Thanked 0 Times in 0 Posts
Okay tried that and I'm still getting syntax errors.
This works
Quote:
SELECT * FROM store WHERE searchPrice <= 10 ORDER BY searchPrice ASC
And this doesn't
Quote:
SELECT * FROM store WHERE searchPrice >= 50 AND <= 100 ORDER BY searchPrice ASC
__________________
Lcd Tv Forum
Melter
View Public Profile
Visit Melter's homepage!
Find all posts by Melter
Sponsored Links