[SOLVED] FULLTEXT search returns nothing

[advancedfuture]

Well i was working on a very basic search form and for some reason I can't it to return anything.

I even put the query into query browser to check if my syntax is correct (it is!) but still it returns nothing. I am trying to search the column 'resume' for specific keyword(s) which i know exist in the column but still nothing... =( Fulltext indexing is enabled.

 

Any idea's by looking at my code why this wouldn't be returning any results?

 

<?php

include 'dbconnect.php';

echo '<form name="form1" id="form1" method="post" action="">
<input type="text" name="search_text">
<input type="submit" name="search" value="Search">
</form>';

//EXECUTE IF THE SEARCH FORM IS ACTIVATED
if($_POST['search'])
{
$search_text = $_POST['search_text'];

$query = "SELECT *, MATCH (resume) AGAINST ('$search_text') AS score FROM profile WHERE MATCH (resume) AGAINST ('$search_text') ORDER BY score DESC";
$results = mysql_query($query);

while($row = mysql_fetch_array($results))
{
	echo $row['username']."<br />";
	echo $row['headline']."<br />";
}

}
?>

[revraz]

May want to try using LIKE with % wildcard instead of Match and Against.

[phpSensei]

<?php

include 'dbconnect.php';

echo '<form name="form1" id="form1" method="post" action="">
<input type="text" name="search_text">
<input type="submit" name="search" value="Search">
</form>';

//EXECUTE IF THE SEARCH FORM IS ACTIVATED
if($_POST['search'])
{
$search_text = $_POST['search_text'];

$query = "SELECT *, MATCH (resume) AGAINST ('$search_text') AS score FROM profile WHERE `resume` like '$search_text%' ORDER BY score DESC";
$results = mysql_query($query);

while($row = mysql_fetch_array($results))
{
	echo $row['username']."<br />";
	echo $row['headline']."<br />";
}

}
?>

 

I think thats how it works, i just don't know what fields your searching.

[advancedfuture]

<?php

include 'dbconnect.php';

echo '<form name="form1" id="form1" method="post" action="">
<input type="text" name="search_text">
<input type="submit" name="search" value="Search">
</form>';

//EXECUTE IF THE SEARCH FORM IS ACTIVATED
if($_POST['search'])
{
$search_text = $_POST['search_text'];

$query = "SELECT *, MATCH (resume) AGAINST ('$search_text') AS score FROM profile WHERE `resume` like '$search_text%' ORDER BY score DESC";
$results = mysql_query($query);

while($row = mysql_fetch_array($results))
{
	echo $row['username']."<br />";
	echo $row['headline']."<br />";
}

}
?>

 

I think thats how it works, i just don't know what fields your searching.

 

This returned 1 result.... despite the fact my query should match multiple results...

[advancedfuture]

for that matter of fact i tried something outrageous... i tried this query

 

SELECT *, MATCH(resume) AGAINST('blaasdasdasdasdasdasdasadsdasdasda') from profile

 

and it returned every row in table 'profile'... and i can tell you this much "blaasdasdasdasdasdasdasadsdasdasda" doesn't exist in any 'resume' column....

 

hmmm still stumped

[phpSensei]

It searches for a keyword in the text, like A B C...etc or a word APPLE, JUICE...etc

[advancedfuture]

So I figured out what was wrong...

 

Apparently NOTHING was wrong with my first query that I posted... but apparently MySQL has to have more than 3 rows in the database for the MATCH AGAINST to work properly....

 

Learning something new everyday!