Welcome Guest, Not a member yet? Register   Sign In
yet another seo url question
#10

[eluser]boltsabre[/eluser]
Yeah, in my forum table i have these fields, if you don't have a structure like this you may want to consider doing a redesign:

id (int, primary key, auto increment)
seo-title (varchar)
title (varchar)
content (text)
date-posted (datetime)
...etc etc

My url structure is like this:
myDomain.com/forum/id/seo-title

Where seo-title is just the normal title with every space and special character replaced with a dash - (and some extra coding to make sure i don't end up with seo-titles with multiple dashes like 'this---is--my-seo-title).

And i just query the db using uri->segement->2, that way your only searching a int field, not a id+seo-title field, thus keeping the db queries as speedy as possible!


Messages In This Thread
yet another seo url question - by El Forum - 07-27-2011, 01:18 AM
yet another seo url question - by El Forum - 07-27-2011, 02:15 AM
yet another seo url question - by El Forum - 07-27-2011, 02:36 AM
yet another seo url question - by El Forum - 07-27-2011, 03:21 AM
yet another seo url question - by El Forum - 07-27-2011, 06:11 AM
yet another seo url question - by El Forum - 07-27-2011, 06:36 AM
yet another seo url question - by El Forum - 07-27-2011, 07:23 AM
yet another seo url question - by El Forum - 07-27-2011, 07:32 AM
yet another seo url question - by El Forum - 07-27-2011, 07:32 AM
yet another seo url question - by El Forum - 07-27-2011, 07:42 AM
yet another seo url question - by El Forum - 07-27-2011, 07:48 AM
yet another seo url question - by El Forum - 07-27-2011, 08:01 AM
yet another seo url question - by El Forum - 07-27-2011, 08:15 AM
yet another seo url question - by El Forum - 07-27-2011, 08:19 AM
yet another seo url question - by El Forum - 07-27-2011, 08:25 AM
yet another seo url question - by El Forum - 07-27-2011, 08:50 AM
yet another seo url question - by El Forum - 07-27-2011, 04:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB