Berone Posted March 18, 2007 Share Posted March 18, 2007 Right now I'm doing that match keyword search... I don't want to do that, I want to do a search through forum posts and topics in PHP and MySQL. SELECT * FROM docs WHERE MATCH (description) AGAINST ('keyword')"; $acc2_res = mysql_query($acc2,$conn) or die(mysql_error()); I just want to do a keyword search through the forum post and topics text. They are in longtext format in my mysql database. I got some fulltext error with the last search. I don't want to have everything in my database have to be separated by commas or have an additioanl field added ot my table for keywords. Quote Link to comment https://forums.phpfreaks.com/topic/43252-trying-to-make-search/ Share on other sites More sharing options...
ignace Posted March 18, 2007 Share Posted March 18, 2007 did you already tried this?: "SELECT * FROM docs WHERE description = '{$keyword}'"; Quote Link to comment https://forums.phpfreaks.com/topic/43252-trying-to-make-search/#findComment-209999 Share on other sites More sharing options...
cmgmyr Posted March 18, 2007 Share Posted March 18, 2007 do you have an id associated with the record? if you do not you will have to make unique primary id's. also you can check this out: http://www.onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html Quote Link to comment https://forums.phpfreaks.com/topic/43252-trying-to-make-search/#findComment-210001 Share on other sites More sharing options...
Berone Posted March 18, 2007 Author Share Posted March 18, 2007 i have unique ids ... wiill that {$keyword} search rank the descriptiopios in order of relativity Quote Link to comment https://forums.phpfreaks.com/topic/43252-trying-to-make-search/#findComment-210004 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.