SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Member
    Join Date
    Feb 2006
    Location
    Virginia Beach
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Full text Search by topic

    I have a fairly simple forum I'm learning how to create. I need to add a full text search. It will need to search by post as well as topic.
    The results should be sorted by relevance.
    I have both rows in my table(post, topic) and am able to post to them and see them in mysqlAdmin.

    I am in somewhat over my head, any help will be appreciated.
    tks

  2. #2
    SitePoint Member
    Join Date
    Feb 2006
    Location
    Virginia Beach
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Full text search with relevance

    I have a fairly simple forum I'm learning how to create. I need to add a full text search. It will need to search by post as well as topic.
    The results should be sorted by relevance.
    I have both rows in my table(post, topic) and am able to post to them and see them in mysqlAdmin.

    Any help will be appreciated.
    tks

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2006
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How about place google search in your site? very simple

  4. #4
    SitePoint Member
    Join Date
    Feb 2006
    Location
    Virginia Beach
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well, I said I would try to learn to program this, so my instructor might be slightly dissapointed, (but might give me some points for thougtfullness) if I just handed him a google search...

  5. #5
    SitePoint Member
    Join Date
    Feb 2006
    Location
    Virginia Beach
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm looking at "relevance" scripts now, thinking of the best way to attemp to code this thing.

  6. #6
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    have you consulted the mysql manual section on fulltext indexing yet? see http://dev.mysql.com/doc/refman/5.0/...xt-search.html
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  7. #7
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    did you read the manual on full text searching?

    Full text searching

    The preceding example is a basic illustration that shows how to use the MATCH() function where rows are returned in order of decreasing relevance.

  8. #8
    SitePoint Member
    Join Date
    Feb 2006
    Location
    Virginia Beach
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you all for your help. Sorry I'm late by about 4 years.


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
  •