Database generated URLs and mod-rewrite

[willoTheWisp]

Hi,

I'm a newbie to mod_rewrite and .htaccess, but not PHP and MySQL.

I'm creating a website in PHP for a client, and they wish to have what they call 'friendly-URLs'. So naturally I'm using the mod-rewrite module and .htaccess.
My .htaccess lines of code are as follows:

RewriteRule ^/?$ index.php [L]
RewriteRule ^login/?$ login.php [L]
etc.

However, I'm also building a CMS which the user can use to create pages on the site. Each of these pages is stored in the database: the data stored for each page is pageid (auto increment), title, url, content etc.
URL is used so the user can specify what the page is called, so in the browser it will appear as www.example.com/newpage

However, how do I set my .htaccess file up so if the user clicks the link of one of the generated pages (called about-us) for example, it redirects to index.php for example?
index.php would then call to the database for the content of the about-us' page.

Any help will be appreciated!

Willo

[danlefree]

Here's how I'd do it:

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/login/ [NC]
RewriteRule . /index.php?title=$1 [L,QSA]

• RewriteCond %{REQUEST_FILENAME} !-f - Apply if requested URI is not an existing file
• RewriteCond %{REQUEST_FILENAME} !-d - Apply if requested URI is not an existing directory
• RewriteCond %{REQUEST_URI} !^/login/ - Apply if requested URI is not affected by your /login/? rewrite
• RewriteRule . /index.php?title=$1 - Parse the request through your index.php file with the $_GET['title'] string set (note that the QSA/Query String Append directive must be specified - otherwise all requests will be passed to /index.php without the $_GET['title'] string)