I was wondering what is the best way to do this.

I want to be able to store the variable and value in a database but use php to turn them into a url variable combo.

Ok lets say I have a database table called locations with this structure

Database Columns

  • location_type
  • location_name
  • location_image
  • location_summary
  • rpg
  • parent


I want the code to take location_type as the variable and location_name as the value

like lets says location_type has the value village and location_name would be leaf

the url would be rpg.php?rpg=naruto&village=leaf

the rpg part will be hard coded but I want to dynamically create the(highlighted in red)

rpg.php?rpg=naruto&village=leaf

from the database, does anyone know of a good way to do this?