Php,MYSQL and htaccess

[sceneguy]

hello people,
me needing some help here.i have built my own custom coded CMS for blogging.i could have used the same old wordpress ,themes,but the intention was to learn the php,sql system. the platform has been developed and its working as it should.but i`m unable to modify the url structure

current structure =

site.com/view.php?id=3

Using htaccess and much researching, i modified it to

sitecom/view/3.html

this one variable(so as to speak - id) is working well.now i wanna include some seo optimized keywords in the URL.As soon the post is created in the admin panel,the seo optimized key words will be added to that field in the table,say "SLUG".
i can make the url

site.com/view.php?id=3&slug=seo-optimized

but i read its not friendly with server as it has to load both the fields to make a match.

now my question is ,is it possible to
make the url patter

site.com/view.php?id=3

and modify it via htaccess to

sitecom/view/3.html

so i want to know how it can be modified to

sitecom/view/3/article-name-from-slug-field.html

Regards


EDIT1:I have gone through the system of wordpress ,but there are so many functions,its complicating the thing even more

sceneguy Reviewed by sceneguy on 9th Feb 2012. Php,MYSQL and htaccess hello people, me needing some help here.i have built my own custom coded CMS for blogging.i could have used the same old wordpress ,themes,but the intention was to learn the php,sql system. the platform has been developed and its working as it should.but i`m unable to modify the url structure current structure = site.com/view.php?id=3Using htaccess and much researching, i modified it to sitecom/view/3.htmlthis one variable(so as to speak - id) is working well.now i wanna include some seo Rating: 5

[deliteblogger]

paste here your current htaccess rewrite rules

[deliteblogger]

Something like this will do it for you:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule view/([0-9]+)/(.+)\.html$ view.php?id=$1&slug=$2
</IfModule>

[sceneguy]

thanks for help deliteblogger. i`ll try it and get back to you. Wont the server load be increased if it requires
1.int ID to match
2.slug STRING to match?

Can i not match ID field and then redirect it to the respetive field

sitecom/view/3/article-name-from-slug-field-for-post-id-3.html