Posted by frizzle on 11/17/90 11:34

Hi Group,

I'm builiding a sort of a news-site, with a mySQL backend.
Nowadays, i come across a lot of news-pages with the
title of the article in the URL. For example this one:
http://www.nieuwnieuws.nl/ (dutch in this case)

Anyway, every article seems to have it's own html-page.
I know that the page in my example actually has php-pages and
a mysql-db.

In my own site, i use htaccess to simulate directories and everything,
but what i wonder is how THIS system works.
If site.com/news/hot_news.html is converted to
site.com/news.php?article=hot_news,
Does this mean that the PHP looks in the DB "WHERE article =
'hot_news'" ?
Meaning it looks for a piece of text instead of an actual id?

Wouldn't it mean the queries would be extremely slow?

I hope my question is clear, since i don't exactly know how to explain.

Thanks, Frizzle.

[Back to original message]