The truth is that the search system on this site does suck. It just searches for the exact phrase you enter in and doesn't bother to break up the words and search for them in any order. I'll bet Rich was in a hurry when he decided to add a search feature to the forums, and this is probably his search code (no offense to Rich who is actually a great PHP coder
):
$search = $_POST['search'];
$search = mysql_real_escape_string($search);
$sql = "select * from posts where board=$boardid and thread_title like '%$search%' order by last_post_date DESC";
$rslt = mysql_query($sql);
while ($posts = mysql_fetch_array($rslt))
{
//list the posts here.
}
Err, umm, something like that. So, he just added a google search to try to fill in the need for a good searching system.
Good performance is better than a good excuse.
CodeSurge -- DBP Editor for serious programmers.