Jump to content

Need an algorithm that can scan fulltext from MySQL database.


dawg00

Recommended Posts

your question seems to be one of SQL rather than one of php, the SQL you are looking for should be somthing like:

 

$query = "SELECT * from `tablename` MATCH (`columnName1`, `columnName2`, `columnName3`...) AGAINST (`keyword` WITH QUERY EXPANSION)";
$result = mysql_query($query) or die (mysql_error);
while ($row = mysql_fetch_array($result)){
print_r ($row);
}

 

does that help?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.