i have a few hundret cities stored in my mysql DB and in another table many customers-IDs which have a restaurant/cafe etc. in this city.

the customerprofil is beeing called like: www.XXX.com/index.php?ID=12345 (not very google friendly!)

 

now i would like to have a script to be able to take the cityname, the kategorie and name of the location from the database and generate a new directory from it - something like this:

www.XXX.com/data/berlin/restaurant/irish-pub.php?ID=12345

www.XXX.com/data/berlin/bistro/hofbraeu.phpID=12346

 

other possibilities/offers are welcome!

 

regards,

robert