Okay, Yesterday i started MySQL and PHP, did the joke things that was in the articles:
My Question is how would i go about designing a site like sitepoint. Database wise.
A Table layout would really help then i can get started.
I know that allot of you have done such things : eg, webdevhq.com just one example ut there are allot more.
One more thing puzzels me: If an article is multi-paged, then does the writer have to write the link to the next page or should PHP automatically insert the relevant page?
In a sysem like SP PHP generates the links to each page of the article.
Table wise a CMS would be similar to the joke system (I haven't looked in detail at it), but instead of storing a joke it would store a page or a paragraph (As SP does).
It's a case of trial and error and reading up on good database design and normalisation - unfortunatly I don't have any resources to point you to but if you to a search for normalisation you will find something in these forums as I know it has been posted before.
How would you make PHP automatically add links?
Simply check for the existance of a further page, if it exists, pull its title and pid and add a link to it.
Not that difficult.
As for your original question.
A table could be set up with these fields:
Status(active, hidden, featured)
Subtitle(title for this specific page)
And so on. Obviously you could get rid of the sub cat field if you wont use subcategories. Just something like that should work.
Would it be a good i dea the change author to aid,
then i could have authors email, description, etc
ya sure, have an AID instead and then join it to a table with author information.