Results 1 to 3 of 3

Thread: mysql, arrays?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Sep 2005
    Posts
    1,547

    mysql, arrays?

    I was wondering if mysql had arrays. Because I want to work on a forum in mysql from scratch (lots of work I know) and need to think of a way to store topics/posts.

    If mysql has arrays I was going to do a table for topics and an array inside the topics table for posts.

    If mysql doesn't have arrays I was going to do a table for topics and a table for posts (very messy imo).

    So does mysql have arrays?

  2. #2
    WiggleWiggle dclamp's Avatar
    Join Date
    Aug 2006
    Posts
    3,527

    Re: mysql, arrays?

    you could do an array inside of each record, but that is not the way to do it for a forum.

    you would want a table for threads, and a table for posts.
    My usual boring signature: Something

  3. #3
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: mysql, arrays?

    SQL databases are relational, not hierarchical. Anything that can stand as its own entity with its own properties — such as a topic or post — should have its own table.

Posting Permissions

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



Click Here to Expand Forum to Full Width