I just realized that it’s been weeks since I had something dorky to say (like programming or something to do with MySQL for example).

Just so you know that I am still dorky, here’s some PHP code for you (from my post over here)…

This will put the keywords that someone searched on to reach your site (works with Yahoo, AOL, MSN and Google) into the $keywords variable.

[code=php]$parse = parse_url($_SERVER[‘HTTP_REFERER’]);
$se = $parse[“host”];
$raw_var = explode(“&”, $parse[“query”] );
foreach ($raw_var as $one_var) {
$raw = explode(“=”, $one_var);
$var[$raw[0]] = urldecode ($raw[1]);
}
$se = explode (“.”, $se);
switch ($se[1]) {
case ‘yahoo’:
$keywords = $var[‘p’];
break;
case ‘aol’:
$keywords = $var[‘query’];
break;
default:
$keywords = $var[‘q’];
}
unset($parse, $se, $raw_var, $one_var, $var);[/code]

Weeeeeeeeeee! Can I go to bed now?

Yahoo’s APIs are really nice (and there are a ton of them). Google’s API for web search is about 15x slower than Yahoo’s (no joke) and has less features. I really wish Google would bring out a new revision for it (its been stagnant for about 3 years now).

Google’s Map API is still better than Yahoo’s IMO, but that’s about it.

You ever wish you could have done something for years, only to realize one day you could have done it this whole time?

I have a couple tables that I was replicating across 3 or 4 MySQL databases because I didn’t think I could reference a table from database A while working with database B.

Today I accidentally tried to do a SELECT on a table from a database I wasn’t even working with and instead of getting an error, it worked. As long as the user you are connected to MySQL as has the proper privileges (duh), it works. You just prefix your table/column name with the database name.

For example:
[code=sql]SELECT database1.tablename.a_column,database2.another_table.another_column
FROM database1.tablename
LEFT JOIN database2.another_table ON(database1.tablename.some_id = database2.another_table.some_id)[/code]

You can do anything you can do with tables in the same database (INSERT SELECT, JOINS, sub-queries, etc.)

Wow, I’m an idiot… its probably been a feature since version 1.0 too. 🙂 Now if you could just do the same thing across different MySQL servers (something like ipaddress.database.table.field), that would be really handy.