I've just been having a look at this, and have gotten halfway to what I would like to do.
So I've got it working by changing my .htaccess file to include:
RewriteRule index/LodgeID/(.*)/ index.php?LodgeID=$1
RewriteRule index/LodgeID/(.*) index.php?LodgeID=$1
Which is rewriting:
And I've resolved the issue of my paths to images and CSS files going AWOL.
What I would like to be able to do is include a variant of the lodge name in the URL.
I do have a field in the lodges table which has a short name string which could be used, e.g.:
Is it possible to use rewrite the URL to:
Where 'lodgename' is stored as a field in the same lodges table as LodgeID?