Results 1 to 3 of 3

Thread: SQL for a Forum

  1. #1
    Join Date
    Jun 2006
    Posts
    4,832
    Tokens
    0

    Latest Awards:

    Default SQL for a Forum

    Hey, I'm making a php forum, and I'm stuck a little...

    For categorys, forums and threads, how would I get them in the right place using what SQL tables?

    I really have no idea, I was thinking about the categorys name (ie The Zone) then it has the forum id's in a row called "forums". Then the forums have the names... but ah, I'm unsure.

    Can anybody think how it'd work? Don't post any code I just need to know how to do it, what to put in tables...

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Posts
    4,795
    Tokens
    0

    Latest Awards:

    Default

    Use a primary key on each of the rows and just create relationships based on the primary keys.

  3. #3
    Join Date
    Jun 2006
    Posts
    4,832
    Tokens
    0

    Latest Awards:

    Default

    OK, I don't think I should do that with ID's then, just with names.

    Thanks Tom.
    Last edited by Hitman; 28-12-2007 at 01:49 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •