mod_rewrite help needed!

[Cobb]

Hi,

I'm basically lost with mod_rewrite! I have a php page that pulls up entries to the db using GET and the id.

So the web address is www.mysite.composts.php?id=1 (for example).

What i want instead is www.mysite.com/title-of-post

Could anyone please give me a hand?
Thanks!

[abduraooft]

Could anyone please give me a hand?

You'd need to generate the "title-of-post" part for each post and save it in a separate column (and then apply some UNIQUE INDEX to it).

That may not be an easy task when considering the chances of two posts with the same title and changing the "title-of-post" column along with any change in the original title of the post.

The easy way is to make the urls like www.mysite.com/1_title-of-post or www.mysite.com/1-title-of-post and then extract the id from url to retrieve it from DB.

[Cobb]

I'm the only one who can put content onto the site, so name clashes won't be a problem.

I'm struggling with mod_rewrite at a more basic level though at the moment.

I can't even turn www.mysite.com/posts.php?id=1 into www.mysite.com/1. (Or any other simple variation on that).

[Cobb]

Ok, so I've changed my SQL querys so that it doesn't use ID's anymore. Instead it searches by a new field, 'url', which i set myself.

So now i have:
www.mysite.com/posts.php?url=whatever-i-chose

But what i want is:
www.mysite.com/whatever-i-chose

Could anyone tell me how i can achieve this?

Thanks!

[abduraooft]

Could anyone tell me how i can achieve this?

Have a look into http://www.google.com/search?q=apache+friendly+urls