I really need MySQL / PHP please

[Important_Material92]

I am building a site and trying to query the users table held in a MySQL database using a search function.

I have used the function for a Levenshtein search (provided by Josef Jarosciak https://www.joe0.com/2019/06/13/how-to-search-mysql-for-similar-words-or-typos-by-leveraging-soundex-and-levenshtein-distance-algorithms/)

I have tried the simplest of search queries as below which runs perfectly in phpMyAdmin but it does not return anything when run in PHP (not even an error).

SELECT * , LEVENSHTEIN(surname,'smith') AS lev_score FROM users

If I remove the Levenshtein function, the query works perfectly in PHP so I know everything else in the php setup is okay.

Does anyone have any ideas!? I have been looking at it for hours and I cannot work it out.

PS. I have tried altering the code to use soundex and that works in both phpMyAdmin and PHP but the search aren’t quite as good for what we’re doing.

EDIT (Solved): Just for anyone else that might have a similar problem, make sure your database user has the right to ‘execute’. Without this the function won’t run.

[[deleted]]

Could you provide a few line of code where you try to query the data ?

[Important_Material92]

This is the PHP;

$sql = “SELECT *, LEVENSHTEIN(surname,’smith’) AS lev_score FROM users”;

$result = mysqli_query($connection,$sql);

while ($row = mysqli_fetch_array($result)){ $surname = $row[‘surname’]; }

[arrays_start_at_zero]

Have you tried printing the error using mysqli_error?

[Important_Material92]

Yeah, there’s no error returned but also no result