Hello,
I am a new member and very new to creating website. I am running into a situation where my ASP/Access database script generates same meta Title, Description and Keywords for every single page. I would like to know if there is a way to dynamically generate meta tags from the page itself using headlines and the content being displayed.
Thank you,
kky2k
Subscribe to HRA Now!
Are you a Google Analytics enthusiast?
Share and download Custom Google Analytics Reports, dashboards and advanced segments--for FREE!
www.CustomReportSharing.com
From the folks who brought you High Rankings!
More SEO Content
International SEM | Social Media | Search Friendly Design | SEO | Paid Search / PPC | Seminars | Forum Threads | Q&A | Copywriting | Keyword Research | Web Analytics / Conversions | Blogging | Dynamic Sites | Linking | SEO Services | Site Architecture | Search Engine Spam | Wrap-ups | Business Issues | HRA Questions | Online Courses
Sponsored Content
Dynamic Meta Tags
Started by
kky2k
, Oct 25 2003 02:25 PM
15 replies to this topic
#2
Jill
-
- Admin
-
- 32,311 posts
High Rankings Advisor
Posted 25 October 2003 - 06:40 PM
Welcome, kky2k! 
There's definitely a way to do that, but it all depends on the type of content management system you have.
Jill
There's definitely a way to do that, but it all depends on the type of content management system you have.
Jill
#3
_Yura_
-
- Active Members
-
- 20 posts
HR 2
- Location:Toronto, Ontario, Canada
Posted 25 October 2003 - 09:11 PM
It is not clear what you trying to do, but from what I undertood here is some idea:
in your DB create table let say "MyPages" which has PageName, Title, Keywords, Description fields.
lets say you have record in this table:
PageName | Title | Keywords | Description
----------------------------------------------------------------------
index.html | fine place | fine, place, cool | this is index page
demo.asp | demo page | demo ,page | this another demo page
so use that code for your index.html or other pages that has record in "MyPages" table
<%
'---- your asp code------
set conn=..... ' connection to your database
'--- get file name of the page (not sure if it correct have to test
)
filename=right(Request.ServerVariables("URL"),RevInStr(Request.ServerVariables("URL"),"/"))
'----- find record which has file name field
set rs=conn.execute("Select * from MyPages where PageName='" & filename & "'")
%>
<html>
<title><%=rs("Title")%></title>
<head>
<meta keywards="<%=rs("Keywords")%>">
<meta description="<%=rs("Description")%>">
</head>
<body>
Your page text goes here
</body>
<%
rs.close
conn.close
%>
</html>
Well hope it will work for you kky2k
in your DB create table let say "MyPages" which has PageName, Title, Keywords, Description fields.
lets say you have record in this table:
PageName | Title | Keywords | Description
----------------------------------------------------------------------
index.html | fine place | fine, place, cool | this is index page
demo.asp | demo page | demo ,page | this another demo page
so use that code for your index.html or other pages that has record in "MyPages" table
<%
'---- your asp code------
set conn=..... ' connection to your database
'--- get file name of the page (not sure if it correct have to test
)filename=right(Request.ServerVariables("URL"),RevInStr(Request.ServerVariables("URL"),"/"))
'----- find record which has file name field
set rs=conn.execute("Select * from MyPages where PageName='" & filename & "'")
%>
<html>
<title><%=rs("Title")%></title>
<head>
<meta keywards="<%=rs("Keywords")%>">
<meta description="<%=rs("Description")%>">
</head>
<body>
Your page text goes here
</body>
<%
rs.close
conn.close
%>
</html>
Well hope it will work for you kky2k
#4
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 25 October 2003 - 09:18 PM
Hi Jill,
I am not using any high end CMS package. I bought an ASP script from DMXREADY.COM. Here is their link:
http://www.dmxready....inksmanager.asp
Then, I had it modified a little bit, see the link below. This link is on a test area of my website.
http://www.thefinals...inksmanager.asp
I am currently experimenting with something which generates meta tags randomly from whatever I put in a lookup file, and it is not very specific to the page therefore I have to keep it very broad.
Thank you for any insight,
kky2k
I am not using any high end CMS package. I bought an ASP script from DMXREADY.COM. Here is their link:
http://www.dmxready....inksmanager.asp
Then, I had it modified a little bit, see the link below. This link is on a test area of my website.
http://www.thefinals...inksmanager.asp
I am currently experimenting with something which generates meta tags randomly from whatever I put in a lookup file, and it is not very specific to the page therefore I have to keep it very broad.
Thank you for any insight,
kky2k
#5
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 25 October 2003 - 09:25 PM
Hi Yura,
Your solution is obviously beyond my skill level at this time, but I will play with it anyway. I am learning and trying to understand ASP these days, so I understand that I will have to add these new fields in the DB and access them in the meta tags.
Thanks,
Kky2k
Your solution is obviously beyond my skill level at this time, but I will play with it anyway. I am learning and trying to understand ASP these days, so I understand that I will have to add these new fields in the DB and access them in the meta tags.
Thanks,
Kky2k
#6
Vertster
-
- Active Members
-
- 327 posts
Google wristbar installed
- Location:Salt Lake City, Utah
Posted 25 October 2003 - 11:42 PM
Hi kky2k-
I could probably give you some help here... I have created similar systems, although I will give you an idea of a better way to do it.
I don't think you want to randomly create your meta tags. What does that mean exactly? That each time the page is served, it uses a different meta tag? Bad idea... You want to set the meta tag once, and leave it alone. That way the spiders can come and index it. If you keep changing it randomnly, every time they come back they will get something different, and I can only think that would play havock with your ranking.
Creating the meta tag from a database query is fine, but only if the whole content of the page is dynamically built. If its not, then I suggest using some page level variables for the meta tags, title, and header, to make sure they are all the same or at least very similar. Ie:
<%
' declare page level keywords/ theme
dim varKeywords, varTitle, varDescription
varKeywords = "Blue Widgets, Widget Retailer"
varTitle = "Blue Widgets are us"
varDescription" = Blue Widgets are us is the largest blue widget dealer east of the Rockies"
%>
...
...
<title><%=(varTitle & " | " & varDescription)%></title>
<meta type="description" value="<%=varDescription%>"
<meta type="keyuwords" value="<%=varKeywords%>">
</head>
<body>
<h1><%=varTitle%><br><%=varDescription%></h1>
yada yada yada page content
This way, your main target keywords are displayed consistently in key areas of the web page, and when/if you want to go edit them, all you have to do is change the page variables.
I could probably give you some help here... I have created similar systems, although I will give you an idea of a better way to do it.
I am currently experimenting with something which generates meta tags randomly from whatever I put in a lookup file, and it is not very specific to the page therefore I have to keep it very broad.
I don't think you want to randomly create your meta tags. What does that mean exactly? That each time the page is served, it uses a different meta tag? Bad idea... You want to set the meta tag once, and leave it alone. That way the spiders can come and index it. If you keep changing it randomnly, every time they come back they will get something different, and I can only think that would play havock with your ranking.
Creating the meta tag from a database query is fine, but only if the whole content of the page is dynamically built. If its not, then I suggest using some page level variables for the meta tags, title, and header, to make sure they are all the same or at least very similar. Ie:
<%
' declare page level keywords/ theme
dim varKeywords, varTitle, varDescription
varKeywords = "Blue Widgets, Widget Retailer"
varTitle = "Blue Widgets are us"
varDescription" = Blue Widgets are us is the largest blue widget dealer east of the Rockies"
%>
...
...
<title><%=(varTitle & " | " & varDescription)%></title>
<meta type="description" value="<%=varDescription%>"
<meta type="keyuwords" value="<%=varKeywords%>">
</head>
<body>
<h1><%=varTitle%><br><%=varDescription%></h1>
yada yada yada page content
This way, your main target keywords are displayed consistently in key areas of the web page, and when/if you want to go edit them, all you have to do is change the page variables.
#7
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 26 October 2003 - 12:34 AM
Hi Vertster,
It will take me a little while to absoreb what you suggested. I have a very simplistic mind about coding at this time. Here is something I found on the web which was the closest to what I wanted. I am sure it can be enhanced by you folks who understand it more than I do.
This script will create dynamic random meta tags based on your session, an interesting approach:
<%
random = 0
RANDOMIZE
randomnum = INT((6 - 1 + 1) * Rnd + 1)
if randomnum = 1 then session("title") = "The Final Store - Online Shopping Mall"
if randomnum = 2 then session("title") = "Apparel - Men's, Women's and Kids' clothing, shoes, toys"
if randomnum = 3 then session("title") = "Books & Magazines at the FinalStore.Com"
if randomnum = 4 then session("title") = "Title4"
if randomnum = 5 then session("title") = "Title5"
if randomnum = 6 then session("title") = "Title6"
if randomnum = 7 then session("title") = "Title7"
if randomnum = 1 then session("description") = "Desc1"
if randomnum = 2 then session("description") = "Desc2!"
if randomnum = 3 then session("description") = "Desc3"
if randomnum = 4 then session("description") = "Desc4"
if randomnum = 5 then session("description") = "Desc5"
if randomnum = 6 then session("description") = "Desc6"
if randomnum = 7 then session("description") = "Desc7"
if randomnum = 1 then session("keywords") = "Keyword1"
if randomnum = 2 then session("keywords") = "Keyword2"
if randomnum = 3 then session("keywords") = "Keyword3"
if randomnum = 4 then session("keywords") = "Keyword4"
if randomnum = 5 then session("keywords") = "Keyword5"
if randomnum = 6 then session("keywords") = "Keyword6"
if randomnum = 7 then session("keywords") = "Keyword7"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<TITLE><%=session("title")%></TITLE>
<META name="description" content="<%=session("description")%>">
<META name="keywords" content="<%=session("keywords")%>">
</head>
Thanks,
kky2k
It will take me a little while to absoreb what you suggested. I have a very simplistic mind about coding at this time. Here is something I found on the web which was the closest to what I wanted. I am sure it can be enhanced by you folks who understand it more than I do.
This script will create dynamic random meta tags based on your session, an interesting approach:
<%
random = 0
RANDOMIZE
randomnum = INT((6 - 1 + 1) * Rnd + 1)
if randomnum = 1 then session("title") = "The Final Store - Online Shopping Mall"
if randomnum = 2 then session("title") = "Apparel - Men's, Women's and Kids' clothing, shoes, toys"
if randomnum = 3 then session("title") = "Books & Magazines at the FinalStore.Com"
if randomnum = 4 then session("title") = "Title4"
if randomnum = 5 then session("title") = "Title5"
if randomnum = 6 then session("title") = "Title6"
if randomnum = 7 then session("title") = "Title7"
if randomnum = 1 then session("description") = "Desc1"
if randomnum = 2 then session("description") = "Desc2!"
if randomnum = 3 then session("description") = "Desc3"
if randomnum = 4 then session("description") = "Desc4"
if randomnum = 5 then session("description") = "Desc5"
if randomnum = 6 then session("description") = "Desc6"
if randomnum = 7 then session("description") = "Desc7"
if randomnum = 1 then session("keywords") = "Keyword1"
if randomnum = 2 then session("keywords") = "Keyword2"
if randomnum = 3 then session("keywords") = "Keyword3"
if randomnum = 4 then session("keywords") = "Keyword4"
if randomnum = 5 then session("keywords") = "Keyword5"
if randomnum = 6 then session("keywords") = "Keyword6"
if randomnum = 7 then session("keywords") = "Keyword7"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<TITLE><%=session("title")%></TITLE>
<META name="description" content="<%=session("description")%>">
<META name="keywords" content="<%=session("keywords")%>">
</head>
Thanks,
kky2k
#8
Vertster
-
- Active Members
-
- 327 posts
Google wristbar installed
- Location:Salt Lake City, Utah
Posted 26 October 2003 - 10:43 AM
Well, that will certainly work. But I am at a real loss as to WHY you would want to do this?
#9
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 26 October 2003 - 11:00 AM
Hi Scott & Yura,
Actually I agree with all of you on this. I was not comfortable with my existing solution above, therefore I am here.
I tried Scott's solution and it works, and I will certainly use it in many situations. This post has been a tremendous help to me in less than 24 hours.
Right now I have created an extra "kewords" field in the DB. I am re-using ParentCategory field as the Title, ParentCategoryDescription as Description and newly created ParentCategoryKeywords field as the keywords, it seems that i am already very close to some sort of resolution. Please see below and critique.
<head>
<title><%=(List_Links.Fields.Item("ParentCategoryName").Value)%></title>
<meta name="description"content="<%=(List_Links.Fields.Item("ParentCategoryDesc").Value)%>">
<meta name="keywords"content="<%=(List_Links.Fields.Item("ParentCategoryKeywords").Value)%>">
</head>
Sincerely,
kky2k
Actually I agree with all of you on this. I was not comfortable with my existing solution above, therefore I am here.
I tried Scott's solution and it works, and I will certainly use it in many situations. This post has been a tremendous help to me in less than 24 hours.
Right now I have created an extra "kewords" field in the DB. I am re-using ParentCategory field as the Title, ParentCategoryDescription as Description and newly created ParentCategoryKeywords field as the keywords, it seems that i am already very close to some sort of resolution. Please see below and critique.
<head>
<title><%=(List_Links.Fields.Item("ParentCategoryName").Value)%></title>
<meta name="description"content="<%=(List_Links.Fields.Item("ParentCategoryDesc").Value)%>">
<meta name="keywords"content="<%=(List_Links.Fields.Item("ParentCategoryKeywords").Value)%>">
</head>
Sincerely,
kky2k
#10
Vertster
-
- Active Members
-
- 327 posts
Google wristbar installed
- Location:Salt Lake City, Utah
Posted 26 October 2003 - 11:38 AM
That looks pretty good. That type of solution helps reinforce the most important keywords/content on your page by ensuring consistency. Just make sure you use the same fields in the actual content of your page, and you will be on your way! 
#11
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 26 October 2003 - 12:54 PM
Thank you! and I owe you one!!! all of you.
kky2k
kky2k
#12
_Yura_
-
- Active Members
-
- 20 posts
HR 2
- Location:Toronto, Ontario, Canada
Posted 26 October 2003 - 03:43 PM
<%=(List_Links.Fields.Item("ParentCategoryDesc").Value)%>
and
<%=List_Links("ParentCategoryDesc")%>
are same things.
:learn:
and
<%=List_Links("ParentCategoryDesc")%>
are same things.
:learn:
#13
kky2k
-
- Members
-
- 7 posts
HR 1
Posted 26 October 2003 - 07:36 PM
Hi Yura,
Yes it worked. You know your stuff, I just mimic and copy whatever works. Dynamic meta tags are pretty liberating.
Thanks,
kky2k
Yes it worked. You know your stuff, I just mimic and copy whatever works. Dynamic meta tags are pretty liberating.
Thanks,
kky2k
#14
mazzy1026
-
- Members
-
- 2 posts
HR 1
Posted 26 November 2003 - 10:29 AM
Hi guys - I have been reading a lot about your dynamic HTML tags and thought I would try and make a contribution. I apologise if this has already been pointed out.
I have been finding websites who appear at the top of googles results. These websites seem to have a massive set of links in the HTML each with different names. When a user performs a search, for example "Nokia 6510 ringtones", the title on the page appears as this and the user is directed to the page called "Nokia 6510 ringtones" - you will also notice that the text on the page has changed to what the user typed in or as close as possible.
I found this website:
http://www.mobilemin...06510-tones.asp
who seem to employ this technique - which appears to work wonderfully. Notice how the text on the page matches what i searched for, as does the meta title. Try doing your own search too, perhaps "Nokia 3510 ringtones" and notice the same thing.
Can anyone explain how this works or what is going on ? It seems to work and gives them top rankings. Ive noticed quite a few websites doing this now.
Kind regards
Lee
I have been finding websites who appear at the top of googles results. These websites seem to have a massive set of links in the HTML each with different names. When a user performs a search, for example "Nokia 6510 ringtones", the title on the page appears as this and the user is directed to the page called "Nokia 6510 ringtones" - you will also notice that the text on the page has changed to what the user typed in or as close as possible.
I found this website:
http://www.mobilemin...06510-tones.asp
who seem to employ this technique - which appears to work wonderfully. Notice how the text on the page matches what i searched for, as does the meta title. Try doing your own search too, perhaps "Nokia 3510 ringtones" and notice the same thing.
Can anyone explain how this works or what is going on ? It seems to work and gives them top rankings. Ive noticed quite a few websites doing this now.
Kind regards
Lee
#15
Scottie
-
- Admin
-
- 6,293 posts
Psycho Mom
- Location:Columbia, SC
Posted 26 November 2003 - 11:11 AM
Yes- there are scripts out there that will do that. I'm not sure what they are called, but I've run across them a few times.
I don't see how it can contribute to the rankings since the search engine spider doesn't send through a query- something has to be on the page to begin with and that is what the spider will index.
I don't see how it can contribute to the rankings since the search engine spider doesn't send through a query- something has to be on the page to begin with and that is what the spider will index.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
