SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Feb 2001
    Posts
    140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Boolean search for a product database

    Hi, I was wondering how I can do a product filter for a hardware product database.

    For example, I want to create a HTML form that allows users to find a product that they want.

    Sample
    ------------------------
    MSRP:
    1. $50 or less
    2. $75 or less
    3. $100 or less
    4. $150 or less
    5. $200 or less

    Capacity (spec1):
    1. 10GB
    2. 20GB
    3. 30GB
    4. 40GB

    Brand:
    1. Adaptec
    2. Maxtor
    3. Seagate

    These options will be in some drop down menu.
    However, there are more than a dozen of product categories, and they all have different attributes. For example, the Capacity (spec1) will have a different boolean setting if it's a different product type. 'spec1' could be using <= or >= statement instead of =. So, the boolean search has to be very dynamic.

    Any suggestions? Do I make any sense?
    Last edited by d-net; Nov 30, 2001 at 01:11.

  2. #2
    web daemon jorasmi's Avatar
    Join Date
    Nov 2001
    Location
    Philippines
    Posts
    296
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just a suggestion.

    First create a page like a directory list of all hardware that you are selling. It then points to a page which contains a search engine specific to the product they selected. This way it will be easier to program the backend.
    What programming language & database are you planning to use or using.

  3. #3
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sure you can use those comparison operators in MySQL. Consult the manual www.mysql.com for more detailed information.

    Example, Select all records where foo is greater than or equal to 50 but less than 100 (50-99):

    SELECT *
    FROM TableName
    WHERE foo >= 50 AND foo < 100


Bookmarks

Posting Permissions

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