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...
Please note this is for PHP!
Hope it help someone...
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";
Hope it help someone...