i was running into a problem while creating a simple database and i hope you can provide me with some help ;).
The problem :
I need to create a database which contains offers (for example for hotels, holidays etc) thats no problem at all. What we want to do is to make each entry customizable with a single url that can be chosen by the author itself. For example we've got an overview page (overview.php) where all the offers are listed. Now i want to click on the first offer "Mallorca" for example which inherits the id 50. The dynamic URL would be something like "detail.php?id=50 for example, but i want to rewrite them from a individual field in my database that the author specified while creating the entry which looks as following :
Offer Name
Offer Date
Offer Price
URL (which can be anything, also blabla.htm)
The URL field should then be used to create a custom individual url for each offer - for example detail.php?id=50 would become mydomain.com/offers/mallorca.htm
I know that mod_rewrite can be consulted but i haven't figured out how to combine it to use fields from my database.
Any advice?