For my fellow Canadians, we ended up with what feels like two very short work weeks. Since Canada Day fell on a Wednesday this year, it’s like we worked two days, got one day off, worked two more days, and now we get two more days off. For our neighbours to the south, you guys get to have a great Independence Day tomorrow. Either way, we’ve got another collection of blog posts for your reading pleasure. It’s got a little bit of everything.

Tyler Ingram took a short trip over to Vancouver Island with Robyn and they decided to go on a whale watching tour. It’s very rare to see the orcas on the ferry routes, so these little tours are definitely worthwhile. Check out some of the terrific shots that Tyler was able to get on his DSLR. That massive lens must’ve come in handy.

Daily Writing Tips has noticed that the MLA standard has been updated to better reflect the way that we access information these days. You all remember the MLA Works Cited rules from high school, right? Well, you no longer have to provide the full URL of a web resource and there are official abbreviations for when you can find the publisher or the publishing date.

Buzz Bishop and his fiance will be exchanging vows tomorrow on their very special day, but this isn’t Buzz’s first time at the dance. He was married to someone else a few years ago and he had to make a decision regarding what to do with the wedding photos. How would you handle the “evidence” of your first marriage? Buzz chose to hit the delete key.

Darren Barefoot may not be from Alberta, but he is still mindful of some of the issues that surround the people who do live there. For example, there is an ongoing debate surrounding Edmonton’s airport. The international airport is just fine at about 30km away from downtown, but the City Centre Airport (a couple minutes outside of downtown) may soon cease to exist in favor of developing the land into commercial and residential property.

Copyblogger noticed that old school marketing techniques no longer seem to work. You can’t just yell at your customers to buy your products anymore and he blames Canada for the change. You see, Canadians are far too friendly to be pushed around like that. You need to provide value and be nice to be a successful marketer with us.

Many small business owners feel that all of their marketing efforts must originate from within. They feel that they have to launch their own websites, market those websites, advertise in the local paper, and so on. While these are all very suitable and very valuable ways to market your company, you also have to realize that potential customers can come from a variety of avenues and one of these is Google.

This goes well above and beyond search engine marketing and search engine optimization. As it turns out, you can get some “free” advertising through Google Maps. Many of us have come to rely on Google Maps for directions, as well as information about local businesses. In this way, you want to make sure that the information Google Maps has on your business is accurate and up-to-date. Thankfully, the process to claim your local business listing is quite simple and straightforward.

The first thing you’ll want to do is search for your business in Google Maps. Assuming that you are not too new, there is a good chance that you have already been indexed. Say, for example, that you own John Doe’s Coffee Shop in Vancouver, BC. You’d search using something like “john doe coffee shop vancouver” as your search term.

When you see the result, click on “More Info” and this will likely bring up your mailing address. On this page, you’ll see an “Edit” link. Click that. The resulting page will a link to “Claim Your Business.” Upon clicking on this link, you can log into your Google account (Gmail, Google Adwords, etc.) and edit the information related to your local business. This can include a mailing address, phone number, website, business hours, accepted forms of payment, and so on.

Even if you don’t expect a lot of business to come via Google Maps, you should claim your local business listing if only as a defensive tactic. You don’t want someone else to claim your business, right?

Thanks to SearchEngineGuide for the inspiration and information for this post.

When you go about choosing a theme for your WordPress-powered blog, you should probably go through the process of testing compatibility in a variety of browsers. Some themes may render perfectly in Firefox but look like a jumbled mess in Internet Explorer. One theme may look fine in Google Chrome, but it could be completely unreadable when viewed through the Nintendo Wii or PlayStation 3. What can you do?

One possible solution is to tweak the code in your existing blog theme so that it is compatible with all of these different browsers. Another possible solution is the unique AVH Themed by Browser WordPress plug-in by A Virtual Home. The idea here is that a different theme is automatically selected when a certain browser is detected.

In this way, someone viewing your blog from a PlayStation 3 can see your blog through a different theme than someone viewing the same blog content through Internet Explorer on a laptop. Some browsers may not be able to handle Javascript or iFrames, but you don’t want to take away those features from people who can view them. By using AVH Themed by Browser, you can really have the best of both worlds.

The most recent version was released on June 21, 2009. For more information and to download the free plug-in, check out AVirtualHome.com. The installation process seems to be relatively straightforward.

Last week we asked if you could add something to your site it would be and 75% said a podcast. This weeks question is…

Now that we have gone over database structures and field types, we can finally create our database. Once we have created our database, we can begin to go over how to interact with the MySQL server using PHP.

The process to create a database will vary depending on your host. However, the basic premise is the same. You create a database along with a MySQL username and password (choose a strong, randomized password). You then associate the MySQL user with the database. Once you have done that, you MySQL database now exists.

However, your database is basically useless, as you currently have no structure to store any data in. To begin adding in your structure, you’ll have to move over to a different tool, which is usually phpMyAdmin. Once you’re in phpMyAdmin, you can begin creating tables and fields in your database.

If you ever get stuck on what field type you should use, refer to the MySQL documentation for an explanation. Get your database all setup and ready for next week, when we’ll be getting into the integration between PHP and MySQL.