SEO Friendly Blog Titles (link)

[eluser]xwero[/eluser]
It's not important if the title matches the id. Amazon does this to if you want to take them as a reference.

[eluser]IamPrototype[/eluser]
[quote author="xwero" date="1232391909"]It's not important if the title matches the id. Amazon does this to if you want to take them as a reference.[/quote]

They do only include the title for SEO, right?

*** Eh, how would I change my meta title and keywords.. I'm asking because I'm include the header in every controller where I need it, and not manually creating more headers.

[eluser]xwero[/eluser]
Yes but i guess they have no SEO problems with linking wrong titles to a wrong id. It's a choice you have to make for yourself.

[eluser]IamPrototype[/eluser]
Nah, the problem was just that I selected my entry from the title, and comments from the ID, so it had to match eachother, so the correct comments or entry would be displayed.

[eluser]xwero[/eluser]
If you add the id you should go by the id to fetch any content. The title in your url to get noticed when people search certain keywords either with a search engine or in their browser location bar.

[eluser]IamPrototype[/eluser]
Yup, I see, thanks

[eluser]John_Betong[/eluser]
 
If you want to use the title method of searching then just ensure that the index you have on title is unique. If a later duplicate is attempted to be added then you must amend the title.
 
Problems will occur with partial matches. If you have only a few titles then this should not be a problem. As far as my jokes site is concerned then I will have to use the ID to ensure the correct search is located.
 
This is working fine on my site and you can check with a Google, Yahoo, Msn, etc search of site: johns-jokes.com
 
 

[eluser]IamPrototype[/eluser]
Sorry, I don't understand the unique part!

[eluser]John_Betong[/eluser]
 
>>> Sorry, I don’t understand the unique part!
 
Hi IamPrototype,
 
If you want to use the title in your URI then it is essential that you do not have duplicate titles otherwise the link will not point to a unique URI on your site. Instead it will find more than one, select one and the other/s will never ever be shown.
 
I have just Googled for MySQL duplicates and come across this script which lists all the jokes on my site with identical titles.

Code:

SQL query:
  SELECT  title, COUNT( * ) AS Count
  FROM    jokes
  GROUP BY title
  HAVING  Count >1;
  LIMIT  0 , 30

 
My next task is to amend the titles so that I can use the unique title in the link and to eliminate the ID.
 
 

[eluser]alectrash[/eluser]
when i blog a photo i store id in database as the "slug" as someone described previously, that way they have tpo be unique cause they are the primary key, in the table.

use this function i made and send it the title of a blog post:

Code:

function make_nice_url($blogtitle)
   {
      $nice_url = "";
      $nice_url_array = explode(" ", $blogtitle);
      
      for($i=0;$i<count($nice_url_array);$i++)
      {
        $nice_url_array[$i] = ereg_replace("[^A-Za-z0-9]", "", $nice_url_array[$i]);
      }
      for($i=0;$i<count($nice_url_array);$i++)
      {
          if($i ==0)
          {
            $nice_url .= $nice_url_array[$i];
          }
          else
          {
            $nice_url .= "_" . $nice_url_array[$i];
          }
      }
      $nice_url = strtolower($nice_url);
      return ($nice_url);
   }

hence:

"fried prawn and cashew nuts dinner delicous"
becomes:

"fried_prawn_and_cashew_nuts_dinner_delicous"

i.e. full url can be

http://www.matthewfedak.co.uk/blog/photo...r_delicous