need help in table design

[[gja]]

Hello There,
i need a little help here guys,my problem is how my table looks like..

I have a range of numbers to insert:

Min - Max = Value
1 - 5 = 20
6 - 10 = 30
11 - 15 = 40
etc...

now,i want it to dynamic,because i make it as a settings in my program to be configurable anytime...example..i will change the max 5 into 7 or maybe 8..by changing it..i will also need to adjust the whole ranges..

my question is..how can make this flexible if a user changed the ranges..into my code?..
and also if a user will like to add more range(e.g 16 - 20)..how can i do that?..any idea?..please help...thanks!..

glen

[sapator]

From what you are describing, o at least from what i understand, you can do:
id - minvalue - maxvalue - finalvalue. That way you can only adjust the ranges that are specific in the id's you want.