create meta tags from php / mysql db

[fish]

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]

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]

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]

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]

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

 

[SF]

Chris you make it sound so easy

 

[retired_member3]

I know, makes you sick!
Bet you can't put a fruit pastel in your mouth without chewing it.

 

[aquanuke]

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

Sounds easy too me

 

[rsteven]

meta tags are a waste of time....

I am surprised that no-one has pointed that out.

I am available for SEO work from Feb next year