Code: Select all
$searchTerm = $_GET['q'];
$searchTerm = mysql_real_escape_string($searchTerm);
$sql = mysql_query("SELECT * FROM Users WHERE firstname LIKE '%$searchTerm%' OR lastname LIKE '%$searchTerm%' OR username LIKE '%$searchTerm%' OR (firstname LIKE '%$searchTerm%' AND lastname LIKE '%$searchTerm%') AND email_activated='1' AND banned='0'");
If i search Gates, It pulls him up in search.
If i search Bill, It pulls him up in search.
If i search Bill Gates, It does not pull him up in search.
Not really sure how to fix this. It would be helpful if i could get help fixing this as i need to build a few different search engines for my site.