Skip to main content
J
jazz823
Inspiring
September 29, 2006
Question

Keyword Search

  • September 29, 2006
  • 2 replies
  • 464 views
My Keyword search is almost complete, how do i add the functionality to scroll through multiple words.

I have a form with a text field called keyword, and the search results work for one word or an exact phrase, i want it to look for all words, I know it has something to do with creata list and looping through it, not sure of the syntax.

Thanks

HEre is my current search query
    This topic has been closed for replies.

    2 replies

    D
    Dan_Bracuk
    Inspiring
    October 2, 2006
    My first thought is that if a product can have more than one keyword associtated with it, and a keyword can be associtated with more than one product, your db should have a table structure to reflect a many to many relationship.
    J
    jazz823Author
    Inspiring
    October 2, 2006
    However the keyword, is a text field. The example I can mention is

    a user puts 18" o-ring joint inthe keyword field and hits search, I would like to pull up any products from the prduct table that contain any of those words, I do not have a keyword table persay, Just want to search the name and escription field for any/all of those words, and Ibelieve I just need to loop through the list created from the items is the text box.
    J
    jazz823Author
    Inspiring
    October 2, 2006
    Any thoughts?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices