Wanted: Service create meta tags from php / mysql db

fish · Oct 24, 2007

Whilst my site collectablefish dot com ranks well for it's title however none of the items in the databse get indexed by search engines.

This is prob a design fault in the website /db build however I'm sure there's a fix to the problem.

Can anyone offer advice or offer services to sort this?

Thnx in advance.

Howie

monaghan · Oct 24, 2007

Drop me a PM with a bit more detail of the requirement and I'll have a look. Assuming the data's OK, it shouldn't be too complicated to pull a few tags & dynamically generate a meta tag.

accelerator · Oct 24, 2007

In my opinion the best way to tackle this is to create distinct pages for each type of thing you want to rank for:

e.g. if you want to rank for fish figurines, then create a page:

fish-figurines.php

Then have a select statement to pull the relevant data from the database (you can use includes for this bit if you want to cut down on maintenance).

Then either populate meta tags manually, or if you want pull them from the database too.

That way you have a chance of ranking. At the moment, all your results are generated from the same page, the only difference being a query string which Google won't necessarily recognise so you aren't ranking under each term.

Rgds

Accelerator

monaghan · Oct 24, 2007

With a bit or URL-rewriting you could probably extract the specific query from the new pages names and pass it into your existing page as the current query string.

aquanuke · Oct 24, 2007

mod rewrite would sort it

ie a page you have

item.php?item_id=91&pic_id=278

could easily be

Early_R_Copenhagen_fish plate_1894_97/91/278.html

Ie grab the item title, plop it in the url and whack the two variables on the end to match with the original url.

Something like

RewriteRule ^$title/([a-zA-Z0-9_]*)/([a-zA-Z0-9_]*).* item.php?item_id=$1&pic_id=$2