Taking control of your future

Quite a while back, SEO blog SEO 2.0 had a post entitled “Hey Freelancer: Are You a Worker or an Entrepreneur?” which really made me think.

Back when I was freelancing as my sole source of income, I was so caught up in being a worker, that I didn’t even realize I wasn’t working towards being an entrepreneur. This article woke me up a bit… too bad it was many months too late! ūüôā

So how about the rest of you out there? Are you worker bees, or are you entrepreneurs?

Contextually relevant search results

A while back, Kyle Baley of CodeBetter.com wrote an article named “The search interface, or “How to find people”” where he discussed the vast array of interesting questions that come up when considering how to make your search results as relevant and useful as possible.

When he mentioned that his database did not support LIKE, I offered another method within Kyle’s comment board. However I had a bit more of detail I wanted to go into, but didn’t have the time to expound then.

Basically, I think many of Kyle’s ideas are spot on, however, the best result may be to simply code a number of queries in, and provide them as fall-back options. Here’s an example in PHP, my preferred language, especially for examples:

$query = $_REQUEST['query'];
 
$max_results = 10;
 
$results = array();
 
$queries = array(
  "SELECT * FROM contacts WHERE last_name = '?'",
  "SELECT * FROM contacts WHERE LEFT(last_name, ".strlen($query).") = '?'",
  "SELECT * FROM contacts WHERE first_name = '?'",
  "SELECT * FROM contacts WHERE LEFT(first_name, ".strlen($query).") = '?'",
);
 
foreach($queries as $sql)
{
  $results = array_merge($results, fetch_all($sql, $query));
  if (count($results) > $max_results)
    break;
}

This way, you can return the ones you feel would be most relevant first, but then make sure you can provide for some of the edge cases as well.

Welcome

I have had blogs in various places before, however they were very content specific, and thus limited what I felt I could present in such a place. Here I have a fresh start to cover what I please.

I look forward to a much more successful blogging venture!

twitter