Ads

Collapse

Announcement

Collapse
No announcement yet.

Mysql full text search help.....

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql full text search help.....

    Thought this might help anyone out who using mysql full text search...

    The following code is very similar the the code i'm using...
    please add comments....

    How to improve this script, whats good/bad about it...


    Code:
    $sql = "SELECT tablename. * , MATCH (keywords, title) AGAINST ('$colname_cat'IN BOOLEAN MODE) AS score FROM tablename WHERE MATCH (keywords, title ) AGAINST ('$colname_cat'IN BOOLEAN MODE) ORDER BY score DESC";
    Please note this is for PHP!

    Hope it help someone...
    .


    Promote your craft site today : Add Your CRAFTS
    (£5.50 a month or £50 per year)

    Fun new blog: Snowboard Stuff
Working...
X