nested mysql structure

[clankill3r]

Hi, how can i create a nested structure with php myadmin, like on the attached image.

 

mysql info:

# Server version: 5.1.31-community

 

[attachment deleted by admin]

[DaiLaughing]

I can't tell what you are trying to nest.  Tables?  Fields?  What is in them?

[clankill3r]

instand of something like this:

(where tweedekamer is the database and the rest are tables)

 

tweedekamer

  -representitives

  -user1

  -user2

  -user3

  -user4

 

I want it like this:

 

tweedekamer

  -representitives

  -tweets

      -user1

      -user2

      -user3

      -user4

 

so the users are in tweets.

 

don't know how else to explain, the tables itself are not the problem, just creating a nested structure.

[DaiLaughing]

You can't have tables inside tables if that is what you mean.  You can use related tables so that every one tweet (?) has one or many users related to it.  Is that what you want?

[max_w1]

Have a look at this article about Nested Set Modelling, i am sure that it will give you a better idea of what you are trying to do.

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

[clankill3r]

damnit what a big threat

 

anyway for people who strand here

 

name one table

 

something

 

and the other

 

something_something_else

 

and it will end up in:

 

something

    something

    _something_else

[DaiLaughing]

I can only echo ck's comment on that linked page as a whole but the first chunk - on The Adjacency List Model - would seem to be enough of an answer for most people.

 

I have bookmarked the page for later consideration of the nested part (when masochism strikes) so thanks for the link max.