Seo Home blog

Not so cool.. lol.

http://www.cuil.com/search?q=gabs

Bigger better but not listed..

Can’t seem to find any of my site indexed… Ah well..  good luck and all that..

Over the last 2 weeks i’ve been working a lot on paging in php.

so… Pretty simple to get first last next and previous to work in php.

Looking at resources on the web I haven’t seen many paging php example including rewriting url for the search enignes so thought i’d put some code up here on my blog.. Hope it helps!

mysql_select_db($database, $con);

$query_prods = $query_list= “SELECT * FROM table”;
//echo $query_prods ;

$query_limit_prods = sprintf(”%s LIMIT %d, %d”, $query_prods, $startRow_prods, $maxRows_prods);
$prods = mysql_query($query_limit_prods, $con) or die(mysql_error());
$row_prods = mysql_fetch_assoc($prods);

The above code is a simple example of the php to create a recordset for the entire contents of “table”..

$maxRows_prods = 6;
$pageNum_prods = 0;

$all_prods = mysql_query($query_prods);
$totalRows_prods = mysql_num_rows($all_prods);
$totalPages_prods = ceil($totalRows_prods/$maxRows_prods)-1;

$queryString_prods = “”;
if (!empty($HTTP_SERVER_VARS[’QUERY_STRING’])) {
  $params = explode(”&”, $HTTP_SERVER_VARS[’QUERY_STRING’]);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, “pageNum_prods”) == false &&
        stristr($param, “totalRows_prods”) == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_prods = “&” . implode(”&”, $newParams);
  }
}

The above part of the php paging code creates variables to create a simple mod-rewrite php paging.

<?php

$currentPage  = “some-keyword/”

if ($pageNum_prods > 0) { // Show if not first page ?>
            <a href=”<?php echo $currentPage; ?>”><img src=”first.gif” border=”0″></a>
            <?php } // Show if not first page ?> </p>
        <?php if ($pageNum_prods > 1) { // Show if not first page ?>
            <a href=”<?php echo $currentPage.”/”.($pageNum_prods - 1); ?>”><img src=”prev.gif” border=”0″ align=”bottom”></a>
            <?php } // Show if not first page ?>
      <?php if ($pageNum_prods < $totalPages_prods) { // Show if not last page ?>
            <a href=”<?php echo $currentPage.”/”.($pageNum_prods + 1); ?>”><img src=”next.gif” border=”0″></a>
            <?php } // Show if not last page ?>
   <?php if ($pageNum_prods < $totalPages_prods) {?><a href=”<?php echo $currentPage.”/”.($totalPages_prods); ?>”><img src=”last.gif” border=”0″></a><?php }?>

The above code shows image for first, next, previous and last however you can of course slam in some keywords here either in the alt tags or as text.. I’ll explain how in a bit..

RewriteCond %{REQUEST_URI} ^/somekeyword/([0-9]+)
RewriteRule ^(.*) /page.php?pageNum_prods=%1  [L]

The above is the .htacess for paging a php page called page.php in the root of the site. Please note “somekeyword” can be changed to theme the paging for example if the query returned all products that are ”red” then the folder could be called “red” to give a little seo help..

The above coding will result in yoursite.com/somekeyword/1 for page 1 yoursite.com/somekeyword/2 for page 2 and so on..

The above is a very simple basic script which I hope helps however now you can start to take it up a gear in regards to seo..

So paging has always been a issuse with SE as page 1 will return the same title des and k/w as page 2 and so on … so how to fix the dup content?

Well always consider the user so look at the result on the page..  Look at them as a human.. What is on the page? How could you describe it ?  The above php limits to 6 results per page..  those 6 items each have a title.. Now depenant on your data the is the key!..

Lets assume your in the RED section of the site so the query retrun all red items.. In the first 6 you have what type of items ? These items are the content of the page along with what that page links to.. By extract the type of items your be able to add them to title and desriptions..

So again assuming RED items include pens,ink,paper,paint… collect this data in array.. Now the key so make sure its reads well to the user. So something like “page 1 red items” could be change to “Red pens, ink paper and paint from xyz”

Basically your giving the user the title + description to what is on the page.. as above if page 2 contained card, cloth,fabric,thick paper .. The title would change from something like “page 2 red items” to “Red card, cloth, fabric and thick paper from xyz”

Of course using “,” in titles and description isn’t a great idea thus its worth looking into this wording dependant on your niche..

Hope that helps someone a little

The bbc seem to think google has started phoographing area in the UK including london see quote:

Street View has already been launched in the US and includes photos of streets in major American cities. Photographing of areas in the UK, including London, is believed to have started this week.

The bbc go on to question about the UK privacy laws for using images and faces with consent..

You can read the full article here: http://news.bbc.co.uk/1/hi/technology/7488524.stm

But the real big question is has anymore seen the google van taking photos ???

I have seen any blogs about a google van as yet but will keep a look out and might pop to london if one is knocking about : )

OMG..

The goverment in the uk want to start a socail network:

Calling all social media experts - UKGov your ideas for new data mashups, and there’s GBP20,000 to support the best ideas:

Some of the things it will include

Mapping information from the Ordnance Survey

Medical information from NHS Choices

Neighbourhood statistics from the ONS

Pretty much all Offical Notices (bankruptcy, official appointments, etc) from the London Gazette

A carbon calculator from Defra

£20k prize for the best idea..

Find out more here: http://www.showusabetterway.com/

google are ending adsense Referrals

I did ok with them but hey good things can come to a end..

Thank you for participating in the AdSense Referrals program. We’re writing to let you know that we will be retiring the AdSense Referrals program during the last week of August

Google are now launching

www.google.com/ads/affiliatenetwork.

FOR the USA only

adsense Refferals did have uk affiliates but according to the email its only for the usa

Ah well..

http://www.google.com/adsense/support/bin/topic.py?topic=14882

I’ve just checked out a post on SER forum to see if it was a copy a paste job .. you know the sort when someone pastes the same thing about a subject on a load of forums.

Anyway.. The point is that the query return zero results but below showed the results without the quotes..

Brand new for me ..

Here is the screen shots:

Close up:

Here is the query:

http://www.google.co.uk/search?q=%22The+inspection+of+searches+will+turn+as+a+helping+hand+for+you+to+find+the+appropriate+

If you haven’t heard of Mr site is a massive cheap cms .. basically a website in a box..

I know loads of people who use it to try selling on the web as it cheap and a pretty good cms for newbies.

Over the weekend and notice went out as follows:

Due to continual problems with Trojan Viruses on the Mr Site servers we would recommend you do not update or republish your site until Mr Site has emailed all users to confirm that this has been rectified.

Mr site has removed its support forum a while back but a unoffical site was setup here: http://www.mrsitemembers.proboards79.com/ 

I hope this guys get it sorted as I know of many unhappy customers who can’t change/update their sites.

This may have a major effect on the UK serps if google block/warn searchers about this…

Mr site, site is down too.. http://www.mrsite.com/   some crazy s**t going on here..

I’m getting 1.4 million indexed pages on google see this link: http://www.google.co.uk/search?q=%22created+at+www.mrsite.com 

I guessing maybe 100,000’s of sites are effect as many of these sites are tiny e.g. 3 pages etc..

I’ve assume this was sort of happening anyway without it be public but yesterday I and all adsense publishers got a email anoucing it!

We’ve recently enabled the Google content network to accept display ads served from qualified third-party vendors. At this time, only ads in English are eligible.

If you’re currently opted in to image ads, you’re already able to receive third-party ads. If you’ve disabled image ads, no third-party ads will be served on your site. (Learn how to enable or disable image ads at

 

https://www.google.com/adsense/support/bin/answer.py?answer=9741.)

I run picture/txt ads on to of a forum I run with 10k+ page views a day which has oftern had high end adverts e.g. DHL targeting the site. I’ve assumed this targeting was NOT directly applied but via some agreement / 3rd party..

I hope my $ are going to go up

I look forward to the results.

Today in 1920 Florence nightingale was born!

Today in 2008 google.co.uk give respest to her on the google.co.uk homepage with a new google logo link to http://www.google.co.uk/search?q=florence+nightingale%27s+birthday&hl=en

With the query “florence nightingale’s birthday”

This isn’t showing on the google.com homepage for me “yet” .. UK thing

Here is the logo:

Here is a bit of info about who she was and what she did.. taken from : http://www.netwrx1.com/CherryAmes/nightingale.html

• Florence Nightingale studied nursing in Alexandria, Egypt, and at the Institute for Protestant Deaconesses in Kaiserswerth, Germany.
• She became superintendent of London’s Hospital for Invalid Gentlewomen in 1850.
• She went to Scutari with thirty-eight nurses early in the Crimean War to direct nursing operations; her efforts resulted in greatly reducing mortality rates among the sick and wounded.
• She founded the Nightingale School and Home for Nurses at St. Thomas Hospital in London in 1860, marking the beginning of professional nursing education.
• In 1907, she received the British Order of Merit; she was the first woman to be so honored.

Amazon has just launched its new front end..

I’m not a mad fan of it but at least it not any worse than before..

I thought i’d check how much the affilates changes have cost me..

WELL i’m not happy lol.. I’m really blogging this so I get off my arse and do some coding for the new xml feed vs the old ones I still use…

One thing of interest is amazon still counts the clicks BUT doesn’t give you any cash for them..

Here is one channel this month:

Clicks

1064

Your Conversion

0.19%

 

 Total Clicks 750
TOTAL CONVERSION 3.20%