When designing skyscraper banners (160×600 and 130×160…etc.) try incorporating your logo in to the top and bottom portions of your banner layouts.
If you only want to include one logo, try positioning the logo in the top or middle portions of the banner.
If you only include your brand identity at the bottom, it’s will most likely fall below the fold (below the initial browser window area) and out of view of the user. Having a logo atop of the banner insures the viewer will be able to identity the brand associated with the message and call to actions.
Banner Design Logo Placement Tips
Fix SQL INSERT problems with PHP addslashes function
If you’ve created you own custom content management system using PHP, you may have noticed problems inserting data. One of the problems could be that your data may have characters that prevent it from being inserted. Some of the character that would cause this type of problem are single or double quotes, backslash, and NUL characters.
You can escape these problematic characters using the PHP function addslashes(). As explained by the PHP manual: It returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote (‘), double quote (“), backslash (\) and NUL (the NULL byte).
As you can see from my example below, I first run the content through the addshashes function and than return it to the same named string “$Page_Content” before passing it to my SQL UPDATE or INSERT statement.
$Page_Content = addslashes($Page_Content); $query = "UPDATE site_content SET Page_Title='$Page_Title', Page_Content='$Page_Content' WHERE id_f='$id_f'"; query_db($query);
How to backup MySQL Database via SSH
First you log in using your terminal application by typing the flowing SSH command:
ssh yourusername@hostname-or-ipaddress
After that, you will be prompted to enter your password. As you enter your password, the text will be hidden. Next we should switch to the “root” user. You can do so by typing the following in your terminal window:
su – root
You will have to enter a password once more. Now navagate to where you would like to store your MySQL database file. For an example of changing the directory to the “public_html” direcotry, type this:
cd /var/www/html_public
Now you can back up your db here using the following command. This command will backup all of your databases. I also chose to compress them after the pipe “|” as a gzip file. Type the following but be sure to change the user name and password to your info:
mysqldump -u yourusername -p yourpassword –all-databases | gzip >databasebackup.sql.gz
You can also target single database using the following:
mysqldump -u yourUserName -p yourDBName | gzip >databasebackup.sql.gz
How to validate Flash absolute url paths
You may want to dynamically change the way your flash file behaves based on where it’s hosted. To do so, you should utilize the “_url” variable to obtain the absolute path of your flash file. Continue Reading »
Adium and Yahoo IM Not Working
Did you notice that your Yahoo login stopped working lately? That is because Yahoo changed the way their im protocol works. You will have to download 1.3.5 update from Adium from here: Continue Reading »
How to Swap Depth using AS3 via setChildIndex
How to swap depth using AS3 via setChildIndex. This will fix the Warning: 1060: Migration issue: The method getNextHighestDepth is no longer supported. Continue Reading »
PHP Remove last character from string
Want to remove the last character from your text. Just use Substr_Replace. This is how. Continue Reading »
Flash and SEO. Why not?
Google learns to crawl Flash
Google has been developing a new algorithm for indexing textual content in Flash files…
Source: http://googleblog.blogspot.com/2008/06/google-learns-to-crawl-flash.html
How to SEO Flash
• Search Engines and Flash
• Requirements for Successful Use of Flash
• SEO Flash Programming
• Example: Making Flash Home Page Spiderable
• Scalable Inman Flash Replacement
Source: http://www.hochmanconsultants.com/articles/seo-friendly-flash.shtml
Here are a few comments on this topic from SearchEngineGuide.com:
“Stoney, You hit the nail on the head and pounded it down with one stroke. I completely agree, I have turned down clients in my own business due to flash sites. Now that I am with an agency I find Flash more common, as many of the businesses are big enough and niched enough where they feel that they don’t need SEO for their website. Oddly enough they are often right. Unfortunately SEO can have a big effect on PPC marketing, and most of these accounts suffer from bad keyword quality scores and thus higher click costs in AdWords.”
“Susan: I disagree slightly. Mostly because it all comes down to the intent. Building a flash only website for Ozzy Osbourne is fine, but e-commerce is not. I think you know what I mean”
“ Working on seo for hotel sites, I’ve come across some stunning creative sites designed with Flash. If the designers had thoughtfully used the Flash applications to “wow” site visitors, ie embedding in otherwise SE-friendly pages, it could be a win-win situation.
Perhaps all of you have seen the June info about making Flash SE-friendly. ( http://googleblog.blogspot.com/2008/06/google-learns-to-crawl-flash.html )”
Source: http://www.searchengineguide.com/stoney-degeyter/why-i-still-wont-seo-flash-websites.php
And from SearchEngineJournal.com:
“Disney does it. And so does Oprah. Even my favorite pizza place does it… Granted these are extreme cases of sites which use flash extensively, but there are other cases where even a little flash can be improperly used. There are also cases where flash is not only appropriate, it is recommended. The question then becomes how to best use flash without affecting search engine rankings”
“Yeah this article doesn’t help a bit. I thought after reading I would be able to find a solution for my all flash website for seo purposes. Thefwa.com is an all flash website, they rank no.1, they didn’t follow your mumbo jumbo about not using too much flash” (Note from Alex: TheFWA.com does not rank no.1. They rank 31,905. Still not bad for an all flash site.)
Source: http://www.searchenginejournal.com/flash-and-seo-using-flash-on-websites/2247/
Cool online tool that will probe a flash file:
http://www.flashprobe.com/
Select UNIQUE or DISTINCT MySQL/PHP Queries
How to filter / remove duplicate items in your database query result using DISTINCT






