Archive | Programming RSS feed for this section

Comparing SERP Rank Trackers

The number of websites I’m managing keeps growing and it’s getting harder to track their rankings, especially if you track more than one keyword per domain. Imagine having just 10 domains and having to track the search engine result pages (serps) for the 10 keywords for each domain. That would be madness! I’ve used several [...]

Read More

Remove Leading and Trailing Characters from MySQL Database

Sometimes you want to remove certain characters from your database but can’t use find and replace because you only want to remove the characters at the beginning and end of a table’s column. This is where TRIM() comes in handy. Here’s how to use it. To remove leading character(s): UPDATE `table` set `field` = TRIM( [...]

Read More

Google Blocking Search Queries

This is what I got for doing Keyword Research. Apparently Google gets lots of automated queries that force them to block queries now. At one time they was a captcha but now they just block me. I wonder how many queries are allowed? I ran a google search on my other computer, a mac, using [...]

Read More

Domain Name: To Dash or Not To Dash

As the internet grows older, it gets more crowded and internet real estate a.k.a. domain names get snapped up left and right. It gets harder and harder to register a short domain name, and even the long ones are taken too! Oftentimes we are faced with a situation on whether to choose a domain with [...]

Read More

How To: Look for a Niche Keyword

Before embarking on an SEO campaign or when choosing a niche market to target, keyword research and careful planning should be done so efforts are focused. Here are some steps to get you started Use Google Keyword Tool to gather relevant keywords. Copy results and paste into Google Traffic Estimator to get CPC, Clicks and Revenue data. [...]

Read More

Apache, MySQL, PHP Installation Checklist and Things to Remember

Apache For mod_rewrite: AllowOverride All LoadModule rewrite_module modules/mod_rewrite.so DocumentRoot “C:/htdocs” For PHP5 ScriptAlias /php/ “c:/php-5.2.4-Win32/” AddType application/x-httpd-php .php Action application/x-httpd-php “/php/php-cgi.exe” MySQL / PhpMyAdmin $cfg['blowfish_secret'] =”; Username and Password PHP rename php.ini-dist to php.ini magic_quotes_gpc = On extension=php_mysql.dll Remember to restart Apache changes to reflect!

Read More