Thanks Jason - I may have been overthinking it.
At the moment the recordset is:
SELECT *
FROM lodges
WHERE LodgeID=ParamLodgeID
Where ParamLodgeID is:
Type: Integer
Default Value: -1
Run-time Value: $_GET['LodgeID']
So I changed the recordset to:
SELECT *
FROM lodges
WHERE Lodge=ParamLodgename
Type: Text
Default Value: -1
Run-time Value: $_GET['Lodgename']
It was a case of sucking it to see, but I wasn't sure about the default value being -1 for text rather than an integer.
And I added:
RewriteRule index/GSG_URL/(.*)/ index.php?GSG_URL=$1
RewriteRule index/GSG_URL/(.*) index.php?GSG_URL=$1
RewriteRule index/(.*)/ index.php?GSG_URL=$1
RewriteRule index/(.*) index.php?GSG_URL=$1
to the .htaccess file.
And that gives me:
http://lodges.goodsafariguide.com/lodgedetails/index/GSG_URL/africanhorseback/
and
http://lodges.goodsafariguide.com/lodgedetails/index/africanhorseback/
I tried:
RewriteRule (.*)/ index.php?GSG_URL=$1
RewriteRule (.*) index.php?GSG_URL=$1
To get to:
http://lodges.goodsafariguide.com/lodgedetails/africanhorseback/
But it didn't like that, and didn't show any data.
Is there a tweak in the syntax, or does it always need to reference the .php page?