Results 1 to 3 of 3
  1. #1
    Full Member
    Join Date
    January 18th, 2005
    Posts
    290
    How do you create a more advanced search feature for your site using PHP and MYSQL. I have tried the 'LIKE' conditional to match a word in my database. Problem is if I want a more detailed search (i.e. blue pink widget), all data that contain all words will appear in my search result. How do I make it show only 'blue pink widget'? TIA.

  2. #2
    Newbie
    Join Date
    January 18th, 2005
    Posts
    4

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    ÄúsTrálíĺ
    Posts
    1,372
    Use fulltext as mentioned above.

    If you insert rows 1 at a time, it'll probably be quicker if you insert all the data, then add the fulltext index.
    eg ALTER table ADD FULLTEXT (product_name, product_description)

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Google Product Search (formally Froogle) items not showing up in search
    By justanotherguy in forum Search Engine Optimization
    Replies: 3
    Last Post: November 29th, 2007, 01:42 PM
  2. Replies: 17
    Last Post: August 7th, 2007, 11:22 AM
  3. Replies: 10
    Last Post: July 14th, 2006, 09:57 AM
  4. Will the datafeeds in the merchants datafeeds thread track my commissions?
    By john9245 in forum Programming / Datafeeds / Tools
    Replies: 5
    Last Post: March 29th, 2005, 09:42 AM

Posting Permissions

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