Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


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
  •