Originally Posted by Arcticwarrio
you might be able to create a variable redirect
RewriteRule (news)(\\/)((?:[a-z][a-z]+))(\\d+)(-)((?:[a-z][a-z0-9_]*)) news/id($3)-DatabaseTitle
I'm not sure why but adding this hasn't made any difference. While i'm not getting the "500 Internal Server Error" - I'm still able to access the content using all 3 versions (id24-*). I suspect my routes.php file at (application\config\routes.php) may be involved. It contains this bit of code:
$route['news/id(\d+)-(.*)'] = "news/view/$1";
If there was a way for me to retrieve the article title from the "news" database (column "title" corresponding to row id) I think the situation would be solved - at least in terms of removing "duplicate" content in the eyes of Google.
At the moment, links to each individual News article are made from a sort of news index which dynamically generates the each news story URL using this:
<h2><a href="<?=site_url()?>news/id<?=$value->id?>-<?=$title?>" style="color:inherit; text-decoration:none;"><?=$value->title?></a></h2>