Comments on this.... please

[itandme]

Hi!

I am planning to set up a site totally database dependent, which means that all content should be placed in one mysql table, and grabbed by doing something like .php?cat=article&id=56.

Then the script formats the output using something like:

if ($cat = article) {
do mysql queries to grab article fields, and to display them on a article way.
}

the advantges doing this is of course that I can easy edit them, publish tme, and sorting/format them, and also of course I dont have to do so much template as I only use one file.

But is there any disadvantages? I can understand if the database gets rather slow later when I maybe have like 50 rows with huge content which the query has to go through.

ty

[mogster]

Hm, I don't understand?
If you are pulling the article content by id, surely it fetches only that articles content?
Like "select * from article where article_id = '$art' ", you don't load the db by leafing through it, you go right in and fetches the details (one row).

And even on the pages where multiple rows are fetched, the load is bearable if you don't pull too much data for each row - just enough to create a link to the article.

knutm

[itandme]

yeah of course but i need the cat variable as the diffirent types of documents/categorys needs difirent kind of formatting.

[gtibok]

I created once a such site
my only problem was the database administrator who stoped the server when he thougt it's not needed (to save on electricity).
PHP an MySQL are realy fast, I don't think you should warry about this aspect