Query help


#1

I need some help writing a query that will return all records = to $submit + or - 10 points. The Variable $submit can = any number from 0 to 600 in the row. This is the query i am using now.
$query = “select * from grt WHERE SRM =’$submit’”;
While it works ok it only returns that specific number which is submited.
I would like a little broader return.
Any help would be greatly appreciated.


#2

check out BETWEEN