Results 1 to 2 of 2

Thread: Range fields

  1. #1
    Join Date
    Sep 2003
    St.Petersburg, Russia

    Question Unanswered: Range fields


    I have the following issue.

    I need to create a hosting catalog like this -

    And my client wants me to an adding form that is similiar to this one -

    As you can see users have an ability to enter a range in the space field. And also they might enter something like this: '50, 150, 300, 5000'. So what db structure should I create to make a similiar things with search capabilitis, so that users can search by a storage size.

    I though about two fields, one for the lowest bound of a range, the second for the highest but in this case hosters wouldn't be able to separate data by a colon.

    Or maybe it's wrth creating an additional table that will contain two fields: HSP id and space.

    What do you think?

  2. #2
    Join Date
    Oct 2003

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts