Storing Articles - Complexity

[mspeppa19]

Hi Everyone,

I am looking for some suggestions on a particular issue I am trying to resolve. I am in no way a programmer, I am actually the customer, but I have a small IT background and love tek-tips cause of all you smarties out there who know the answer to every issue I have ever had. So here's my issue:

I am creating a website that will be a compilation of thousands of articles, each in particular categories, accompanied by keywords and also accompanied by a topic that the user can use to search, I want to make sure that it is easy for ME the client to maintain these articles and add more/update at my own whim. Here is an example:

Article #1:
Title: Basics of Dental Health
Category: Dental Center
Topic: Dental Health
Keywords: cleaning, teeth, upkeep

Article #2:
Title: Raising a Baby
Category: Baby 0-1 Years
Topic: Baby's First Year
Keywods: new, baby, raising


Here is the thing: The category shows what section of the site that it goes on...The Topic is a seperate page which is like an index of everything on the site. So instead of me having to update the topics page, it should all be interconnected in the database to automatically reflect those changes. So, if a user visits the site index, and clicks on "Dental Health" then, this article/page plus any other articles/pages should show up. As far as keywords go, an advance search is needed so that if a person types in "cleaning teeth" or "cleaning or teeth" it will look through ALL of the keywords, not just the first one and return those that match (also there could be a number of keywords, not only 3, but could be unlimitd number)

If anyone has any examples of a complex database management tool that can be used/has been used, or any other suggestions it would be greatly appreciated!

Thanks,

MsPeppa

 

[Kozusnik]

phpMyAdmin works great. Here's how I use it.

I run Linux with Apache as the webserver. phpMyAdmin is loaded in the http root also. I use a .htaccess file referencing a conf file in /etc to control access to phpMyAdmin. I have several databases and applications running on this box. Most of which handle the input through the php code I've written. However, there are some cases where I need direct access to the mySQL engine to create or modify tables. I have found that phpMyAdmin is easier than keying in my changes through the mysql prompt.

I hope I answered the right question. The tough part is understanding how it all works together. phpMyAdmin makes database administration easy.

Mark