why i am not getting any thing when i use the command match in php and mysql

when i write this code and run the script i get no error and i get nothing but
one of my rows in d_title  --  have fsd in it
but when i search i get nothing while i need to get wow one time
$query = " SELECT d_title FROM link  
                WHERE MATCH (d_title) AGAINST ('fsd')"; 
    $res = mysql_query($query) or die(mysql_error()); 
    while ($row = mysql_fetch_array($res))
	 {
    echo "wow";
}

Open in new window

mgtm3Asked:
Who is Participating?
 
hieloCommented:
you need to use a MyISAM table AND you need to create a fulltext index:

CREATE TABLE `link`(`d_title` TEXT, FULLTEXT(`d_title`)) TYPE=MyISAM;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.