using the mysql fulltext stunt within a php page to run a kinda search within my db. To be specific, here goes the query:
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)
but still got no reslut returned...wat could be wrong?
Code:
select *, match(url, title, comment) against ('movies') as score from dir
where match(url, title, comment) against ('movies') limit $somevariable, 10
Code:
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>»<A href='$dir/$subdir'>$dir/$subdir</A> hits: $hits</TT><BR>\n";
}