Skip to content
Advertisement

Search Engine Developement using MySQL relevancy, not working on PHP

i’m working on search engine developement. I’m kinda struggling with an SQL/PHP request. I’m trying to get the highest relevancy score from a search query. It works perfectly on SQL, but not at all on PHP, neither on localhost nor online (while the source code is generated by phpmyadmin itself).

Obviously SQL connection works, since other requests are working very well. Any idea ?

Source = https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html

Advertisement

Answer

You need to fetch the results from the resource $result:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement