Rewriting URLS in htaccess?

Hi Everyone,

I have a question regarding rewriting URLS in php while using data from your MySql database. Let's say for example I want to use certain keyword(s) from my database in my meta tags and URLS how would I go about doing that writing that in .htaccess?

Would I have to create variables for certain keywords in my MySql database?

For example, $product, $location

etc ....

and then place the above variables in my meta tags and URLS? and then reconfigure my .htaccess?

Thanks for everyones help!

Here is a simple solution that I used once...

.htaccess file:

RewriteEngine On

RewriteRule ^product/([0-9]+)/([^/]+)$ /product.php?id=$1&d=$2 [NC,L]

Your URLs would be along the lines of:-

http://www.yoursite.com/product/123/PRODUCT-NAME-HERE

http://www.yoursite.com/product/74/PRODUCT2_DESCRIPTION_HERE

Then, in product.php simply get the value of id.

$id=$_GET['id']

How you setup your mod rewrite is very dependant on how you want to structure your URIs. The example above shows a typical example but that may not be what you want.