Archive for February, 2007

« Previous Entries

28th Feb 2007

Australia Day Flyover Images Live

Were you out and about at one of the following places on Australia Day 07? If you were, you might find yourself in google maps.

Australia Day is over, but the hi-resolution photography we took in Sydney Harbour during the celebrations is now live on our site. As you may know, Sydney was the first city Google chose to undertake an initiative like this at such a grand scale. While we couldn’t reach everywhere we’d hoped, we captured some great imagery and want to thank everyone who participated for helping make this celebration so much fun. We hope you’ll take a look, explore and re-live the day with us.

Thanks to Alex for forwarding the newsletter from Google.

Technorati Tags: , , , , ,

Posted in WWW, Google | 1 Comment »

27th Feb 2007

Golden Green WordPress Theme - Download

Golden Green

Golden Green WordPress Theme (pic above) is now available for download.

Features:

  • Links to all pages with an excerpt
  • Advertisement spot (Leaderboard) in the header of all pages
  • A matching favicon
  • An image logo
  • Links to 10 recent posts on the homepage
  • Links to random posts at the footer - You will need to install Random Posts plugin for this to work

It’s designed for WordPress 2.1 but it should work with others. Please let me know if it doesn’t.

Technorati Tags: , , , , , , , , , , , , ,

Posted in WordPress | 2 Comments »

26th Feb 2007

Technoratic Top Tags

Technoratic Top Tags

How weird!

Technorati Tags: , , ,

Posted in WWW | No Comments »

26th Feb 2007

New Theme: Golden Green

Golden Green

What do you think of my new wordpress theme - Golden Green?

Technorati Tags: , , , , , , , ,

Posted in WordPress | No Comments »

26th Feb 2007

Remove the first character in mysql

UPDATE `tablename`
SET `columnname` =
TRIM(LEADING  'THE CHARACTER YOU WANT TO REMOVE, eg: A'  FROM `columnname`);
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)

Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. remstr is optional and, if not specified, spaces are removed.

mysql> SELECT TRIM('  bar   ');
        -> 'bar'
mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
        -> 'barxxx'
mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
        -> 'bar'
mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
        -> 'barx'

This function is multi-byte safe.

Source: MySQL 5.0 Reference Manual

Posted in Snippets | No Comments »

« Previous Entries