Do you have a table which holds these names?
i.e
LocationID
LocationName
?
EDIT: just re-read your post =) I would go with the option of a new table, which could just be grabbed via:
return $DB->table('Locations')->select( ['LocationName', { LocationID => $_[0] } )->fetchrow;
}
(only an example - as I don't know what table structure you will have =))
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
i.e
Code:
LocationDetails LocationID
LocationName
?
EDIT: just re-read your post =) I would go with the option of a new table, which could just be grabbed via:
Code:
sub { return $DB->table('Locations')->select( ['LocationName', { LocationID => $_[0] } )->fetchrow;
}
(only an example - as I don't know what table structure you will have =))
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!