So here we go.
I've ran into problem while trying to get fulltext to work with sql. I was thinking some fresh eyes would point out my mistake.
Code: Select all
<?
$sql = "SELECT *, MATCH(search) AGAINST('".$search."' IN BOOLEAN MODE) AS score FROM testtable WHERE MATCH(search) AGAINST('".$search."' IN BOOLEAN MODE)";
while($sql2 = mysql_fetch_array($sql)) {
//output here
}
?>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/pages/fulltext.php on line 65
Thoughts? And thanks for taking a look at this.