Hello,
I am trying to get this search engine to search for more than two keywords.
I have got a script which I need to change but unfortunately it’s not working. I have tried to do it multiple ways. But at the moment it is searching for just username and name;
The first source;
$queryMsg = sprintf("SELECT * FROM users WHERE username RLIKE '%s' OR name RLIKE '%s' ORDER BY idu DESC LIMIT %s", mysql_real_escape_string(str_replace(' ', '|', $_GET['u'])), mysql_real_escape_string(str_replace(' ', '|', $_GET['u'])), $resultSettings[1]);
$queryMsg = sprintf("SELECT * FROM users WHERE username RLIKE '%s' AND idu < %s OR name RLIKE '%s' AND idu < %s ORDER BY idu DESC LIMIT %s", mysql_real_escape_string(str_replace(' ', '|', $_POST['u'])), mysql_real_escape_string($loadmore), mysql_real_escape_string(str_replace(' ', '|', $_POST['u'])), mysql_real_escape_string($loadmore), $resultSettings[1]);
i have tried doing it like
$queryMsg = sprintf(rest of code)
$queryMsg = sprintf(rest of code)
$queryMsg = sprintf(rest of code)
and just replaced the 'username' and the 'name' with 'description' and the 'age'
It would be great if you could help.
Johnny
