Articles
Sometimes you want to show future posts, likely when you have posts that are events.
<?php
// ———— added for events to show future
if(is_category(‘events’))
query_posts($query_string . ‘&order=ASC&post_status=future’);while (have_posts()) : the_post();
if(is_category(‘events’)) {
if(strtotime($post->post_date) < time())
continue;
}
?>
Whether you’re a beginner in SEO or a seasoned pro, it’s important to keep up on how your pages will be displayed in the Search Engine Results Pages (SERPs) across each engine. Every engine displays your page differently and depending on what you are trying to target there are different approaches to optimizing by engine. This article is not to tell you how to optimize your pages, it is merely to give you the current character count that is displayed for the Title Tags and Meta Descriptions for Google, Yahoo, Bing and Ask.com
A few years ago (2004), Yahoo would display up to 120 characters in the Title Tag. Can you believe it? So much has changed since then. Earlier this year, we had MSN. Now we have Bing. Do you know the proper meta description length displayed in Bing?
Google shows 69 Characters (Including Spaces) for Page Title.
Google shows 156 Characters (Including Spaces) for Meta Description.
It should also be known that if you don’t include a Meta Description or if Google feels a better description for your page could be given by using a web snippet, then the description shown can be up to 320 characters. Of course, they won’t be the characters that you choose so they might not best represent what you wish your audience to see in the SERP’s.
Also, check out SEO Tidbits to see a Google engineer explain why Google does not use Meta key words at all.
Yahoo
It appears that Yahoo shows up to 72 Characters (Including Spaces) for a Page Title. (PDF’s up to 75 characters)
Yahoo shows up to 161 Characters (Including Spaces) for Meta Description.
Bing
According to the Bing Webmaster Blog:
Bing shows 65 Characters (Including Spaces) for a Page Title Tag.
Bing shows up to 150 Characters (Including Spaces) for Meta Description Tag.
However, as you can see in the example above, Bing will readily show 69 characters for the Title Tag and up to 185 for the description.
Ask.com
Ask shows 69 Characters (Including Spaces) for an SEO Page Title.
It appears that Ask.com pulls a snippet of text from the page and can commonly display around 312 characters for a description.
Credit: SageRock
One must be very wary of paying for SEO on their site. Click HERE for a harsh critique of those making a living doing SEO.
Here is a useful short video from Google saying they don’t use meta keyword tags at all:
Thanks Matt Varone on this function to check if the current page is a subpage. WP should have made this a core function
http://www.mattvarone.com/wordpress/is_subpage-function/
A useful companion item is to create a template for a parent page where you only want to redirect it to the first subpage. Sometimes you don’t want a page for the parent at all, just the children.
From WPRecipes:
http://www.wprecipes.com/wordpress-page-template-to-redirect-to-first-child-page
Cursors are frowned upon, but I have found times when performance of update query sets are too slow. I believe this happens when the recovery model is full.
The T-SQL below creates a cursor on a table and then steps through each record and updates several fields. This ended up taking about 4 minutes on an 18k record database, which is small, but would take 20 minutes just to update 200 records in the same table with an update query.
ALTER procedure [dbo].[sp_updateDemoData] as
declare @mallId nchar(6)
declare @RowNum int
declare @showme intset @showme = 0
declare malllist cursor for
select mallcode from mall_exp_trend_2010 where pop_20 > 0
OPEN malllist
FETCH NEXT FROM malllist
INTO @mallId
set @RowNum = 0
WHILE @@FETCH_STATUS = 0
BEGIN
set @RowNum = @RowNum + 1
set @showme = @showme + 1Update e set
e.NUMBER_OF_HOUSEHOLDS_10 = ns.HH_10, e.NUMBER_OF_HOUSEHOLDS_20 = ns.HH_20, e.NUMBER_OF_HOUSEHOLDS_5 = ns.HH_5,
e.AVREGE_HOUSEHOLD_INC_10 = ns.INC_10, e.AVREGE_HOUSEHOLD_INC_20 = ns.INC_20, e.AVREGE_HOUSEHOLD_INC_5 = ns.INC_5,
e.MEDIAN_AGE_10 = ns.AGE_10, e.MEDIAN_AGE_20 = ns.AGE_20, e.MEDIAN_AGE_5 = ns.AGE_5,
e.POPULATION_10 = ns.POP_10, e.POPULATION_20 = ns.POP_20, POPULATION_5 = ns.POP_5
from mallsysNetT1.dbo._mall e, mall_exp_trend_2010 ns
where ns.MALLCODE = e.MALLCODE and e.MALLCODE = @mallId;if @showme = 100
BEGIN
print ‘processed records: ‘ + cast(@RowNum as char(6)) — + ‘ ‘ + @mallId
set @showme = 0
ENDFETCH NEXT FROM malllist
INTO @mallId
END
CLOSE malllist
DEALLOCATE malllist
WordPress is an amazing product, and Fantastico Deluxe helps with the install, but there are some issues and best practices.
When installing WP using Fantastico, make sure the permissions are secure after installation. Fantastico usually sets permissions on the public_html directory to an incorrect “755″. Make sure they are “750.”
Make sure the wp-config.php file permissions are set to “400.”
I’ve had two sites hacked into soon after installation so this is not just an academic exercise.
Settings
- Definitely change the permalinks. I don’t know why they default it with a URL (?p=123) format. You want smart names for your links. If you are going to add lots of posts, you may want to select the “Month and name” format. If not, go to custom Structure and put in /%postname%/
- Under media, you will likely want to uncheck the “Organize my uploads into month- and year-based folders”, unless you will have messloads of images you’ll be uploading. Definitely check the settings for sizes of images in medium and large. You will likely want to reduce the large to something like 800 px max.
- Reading — Unless this is a straight blog, you’ll probably want to create a page called “home” and one called “blog” and then go to the reading panel and set the front page display to static and set the home and blog pages.
Here are some must-have plugins:
- BackupBuddy — Premium (not free) plugin is the best in class to back up and migrate your site or just back up to the cloud or anywhere.
- Gravity Forms — Another best in class premium plugin for building forms.
- WP-Filebase — Great way to organize files and set up downloads.
- Facebook Page Publish — Will push posting to your FB page.
- WP to Twitter — Will push posting to your Twitter feed.
- Google XML Sitemaps — Will keep your sitemaps xml file up to date
- WP Better Emails — Changes the default “WordPress” email address and name to a nice HTML template with custom name and graphics
- WP Show IDs — This replaces “Reveal IDs for WP Admin” because it shows ids for custom post types also
- Theme My Login — Creates a nice login page based on the active theme.
- NextGen Gallery — The best in managing pic galleries
- Regenerate Thumbnails — In case you change the thumbnail sizes, this will recut them all.
- List category posts — Useful if post categories are used as a taxonomy, and you want to get a list of specific categories.
- Custom Post Type UI — This takes advantage of WP 2.9+ custom post types.
- Members — This plugin allow the admin to manage roles for different levels of users.
- White Label CMS –This customized the admin section. You can minimize to the items you want the user to see.
- CMS Tree Page View — This will insert a new menu item under page which gives a tree view of the pages. For sites with lots of pages and subpages, this is a better way to navigate pages in the admin section.
- Google Analyticator– There are several Google Analytics plugins, but this seems the best, which includes a nice dashboard widget/panel to view analytics from WordPress.
- Simple CMS — This is a basic plugin that simplifies the admin page for Editors and below. There is no way to change the settings, but it is a quick way to reduce the clutter for clients.
After my latest WordPress update (manually exporting mysql) I ended up with all my apostrophes appearing as “â€TM” –stupid junk characters. I finally figured out the solution, even though I don’t know exactly why it happened.
It was quite simple, jump in my wp-config, and comment out two lines.
# define(‘DB_CHARSET’, ‘utf8′);
# define(‘DB_COLLATE’, ”);
It worked like a charm.
It would be nice for SQL Server to copy rows like Excel. It is a pain to include all the fields. Below is dynamic SQL to copy the entire row based on the auto id number:
[code]
declare @sql varchar(8000)
DECLARE @TableName varchar(100)
SELECT @tableName = 'tblMyTable' --put urTableName Here
SELECT @SQL = COALESCE(@sql+',','')+ COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tableName AND COLUMNPROPERTY(OBJECT_ID(@tableName),COLUMN_NAME, 'IsIdentity') = 0
EXEC( 'INSERT INTO '+@tableName+' SELECT '+@SQL+' FROM '+@TableName +' WHERE auto_id = theIDNum') -- put auto id fieldname and id num
[/code]
Floats field types have their perils. It is the field type that often defaults on an import from Excel, where the field type has to be guessed.
If you try to change the field type to VarChar you get something like “4.00309e+006″
You can first convert from float to bigint and then to VarChar, or create a new VarChar field and use the following SQL. This is for SQL Server.
update tblMyTable set VarCharField = cast(CONVERT(bigint, floatField) as varchar(10))
Search Engine Optimization (SEO) and Search Engine Marketing (SEM) are all the rage, though both systems are merely new approaches to age-old marketing principles that successful companies have always benefited from.
Wikipedia defines SEO as the process of:
…improving the volume and quality of traffic to a web site from
search engines via ‘natural’ (‘organic’ or ‘algorithmic’) search results.
On the other hand, SEM includes a broader online marketing approach that includes paid placements.
Many companies claim they offer SEO as one of their premerie services.
We do too.
But FSI take is a step further and applies its wide and varied marketing experience to current web and SEO/SEM standards. We apply the following basic principles to help build a successful site:
- Positioning – Analyzing your target audience and competition to best position your site with the equivalent of a
“unique selling proposition”. This includes:- Analyze the competition, finding their strengths and also gaps/opportunities your site can provide.
- Optimizing website content and structure to differentiate your site from the competition
- Conducting a key-word analysis to see how prospects are searching for similar products/services
- Findability – It doesn’t matter how good your site is if prospects can’t find it:
- Making sure search engines know where to find your site.
- Building inbound links to your site to increase your site’s search ranking and generate more traffic.
- Attracting local traffic to your site through free and paid sources
- “Stickiness” – You can rank #1 everywhere and drive thousands of visitors to your site, but if it is poorly written, and lacks a compelling message or “call to action”, people will “slip away” as quickly as they arrived. We have professional writing experience, so that your site isn’t a
mish-mash of key words and phrases, but tells a cohesive and compelling story.



