#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Den Laeghe Landen
    Posts
    107
    Rep Power
    15
    Hi,
    more and more pages seem to be extracted entirely from a database.
    Not only dynamic information, like search-engines, but also (semi-)static content, (just text/information)

    Does anybody know a good tutorial on:
    how to set up the needed effective structure for these database-driven websites?

    Thanks in advance!

    EyE

    ------------------
    --
    ...tiktak...tiktak...
    --
    ...Tommyknockers, Knocking On Your Door...
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    you can see some good article in http://www2.phpbuilder.com/ about setting up of database-driven websites.

    Also check it out http://www.hotwired.lycos.com/webmonkey/
    for getting some good informations.




    ------------------
    SR -
    shiju.dreamcenter.net
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    43
    Rep Power
    15
    We just finished a completely dynamic site recently. Essentially our database has the following tables:

    1. Items - contains all the content
    2. Categories - A list of all the categories, setup in a tree like structure.
    3. CategoryItems - A table related to categories, that contain a list of items that are attached to each category
    4. ItemsRelated - A list of items that are related to other items.

    The above structure has a lot going for it. You can have an article appearing in more than one category, you can have many articles related to one article, thus creating hyperlinks.

    This is also great for creating a front-end catalog for a shopping cart as well.

    If you'd like a detailed list of tables/fields, you can contact me.


    ------------------
    PHP, Perl, SQL Programming at http://www.mentalobjects.com

Similar Threads

  1. maysqladmin drop database syntax?
    By Slurm in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 06:07 AM
  2. MFC and return values of stored procedures
    By Ritch in forum Firebird SQL Development
    Replies: 3
    Last Post: January 28th, 2004, 03:32 PM
  3. Replies: 4
    Last Post: January 11th, 2004, 12:34 PM
  4. Replies: 8
    Last Post: January 3rd, 2004, 01:36 PM
  5. Stored procedure, MSSQL Changed database context error
    By jkrew_devshed in forum PHP Development
    Replies: 1
    Last Post: December 30th, 2003, 04:40 PM

IMN logo majestic logo threadwatch logo seochat tools logo