This is kinda hard to explain, but here goes....

I have a db table called "number_range" with 2 columns: `start`,`end`

I have a number inside both of these columns:

start|end
45000 | 45999
34000 | 34999
12300 | 12355
55710 | 55788


I have a variable: $number = ?, which I need to see if there is a range it belongs to. Or if a range exists.


Each record is a number range. I have thousands of these. I was thinking about actually entering the number range, into 1 column, which would increase my record count quite abit. Not a problem, but I thought I'd ask if anyone knows a way to take my first number ($number) and see if there is a record that ($number) belongs to.

Or if someone can imagine a better way around this. Just diggin for ideas.

thanks guys!