This should pick up any pattern that shows up in the search string right?
Code:
$result = mysql_query("SELECT url, title FROM fappageinfo WHERE title LIKE '%{$searchstring}%' ORDER BY dateadded DESC") or die('error database');
For some reason, It isn't picking up the first word in the column. I tried
Code:
$result = mysql_query("SELECT url, title FROM fappageinfo WHERE title LIKE '%{$searchstring}%' OR title LIKE '{$searchstring}%' ORDER BY dateadded DESC") or die('error database');
But this didn't work either.
For example title "transvestite threesome tea party"
Search returns for "threesome" or "tea" but not transvestite.