SELECT a range from a database

[forumnz]

How can this be done. Let's say there is a from with a dropdown box with an option to select from database where id is between 20-30. How is this done?

 

Would it be ...... WHERE `id`="20-30"......?

 

Or what?

 

Thanks! Sam.

[Fadion]

You could use:

 

SELECT col1, col2 FROM table WHERE id BETWEEN 20 AND 30

[s1yman]

I know you can use a greater than AND less than query for dates, so would assume you can do similar thing here.

Is your "ID" a unique field or there going to be a random amount of records between any two numbers queried?