php vs mysql fulltext

[kehers]

using the mysql fulltext stunt within a php page to run a kinda search within my db. To be specific, here goes the query:

select *, match(url, title, comment) against ('movies') as score from dir 
where match(url, title, comment) against ('movies') limit $somevariable, 10

using mysql_num_rows however, the result count returns 0 but when i ran the query through phpMyadmin, it query returns 1 result. i went back to my script and used dis: (to see if a result was returned despite mysql_num_rows returning 0)

while(list($url, $title, $comment, $subdir, $hits) = mysql_fetch_array($result)){
echo "<a href='hits.php?u=".base64_encode('[URL unfurl="true"]http://'.$link)."'[/URL] target=_blank>$title</A> 
$comment <TT>&raquo;<A href='$dir/$subdir'>$dir/$subdir</A> hits: $hits</TT><BR>\n";
}

but still got no reslut returned...wat could be wrong?

 

[DRJ478]

Insufficient amount of information for a meaningful answer.

Have you echoe'd out your SQL statement from the script?
Have you pasted that statement into PMA and observe the result?

 

[kehers]

Sorry...wat do u mean by PMA?

 

[DRJ478]

PHPMyAdmin is often abbreviated into the acronym PMA.