Need Help Coding This CMS For My Website

[Andrew Cooper]

Ok, so, heres the website structure, so to speak.

 

I'm hoping to build a content management system, now I've got the basics so far, a login system, an article to put up and edit and delete, and who published the article and so on. But, I want a bit more, and I'm confused on a few things, if you could help me out please, it would be great.

 

http://cmsblog.freehostia.com Is the index page. If you take a look at the second listing down, in the second/middle column its links are working correctly. Thats because I've put them in myself. Basically, I want everything that the second article is, but using my CMS, and it's not advanced enough, feature wise, for it to do this.

 

The actual article will be posted, if its an article im posting, will be posted in the Articles folder. And it will have its own web page ofcourse. In this case, it would be: http://cmsblog.freehostia.com/Articles/the-future-of-the-web.html. Which would then be listed on the main Articles folder index, which is here: http://cmsblog.freehostia.com/Articles/index.html and also listed on the main index page.

 

The latest article/tutorial from each category will be posted into the website as it is shown on the main index page. If you get me. There will only be on Article listed on the front index page at any one time, that will be the latest article posted. Same for the rest, etc etc.

 

Also, I want to be able to do pagination on the article itself. As you see it.

 

What I'm struggling with mainly is the actual MySQL tables and columns and what not that I would actually need to have for this to work and what the PHP code for it would be. It's complicated, I know lol.

 

I've waffled on probably a load of rubbish and you probably won't understand what I'm talking about cause I struggle wording and exressing myself but meh. I'll have to see what replies I get back, if any, hopefully.

 

Please, Help!

 

Thanks!

 

- Andrew Cooper