User or Image belongs to many groups in MySQL? How do you do this?

makeshift

I'm creating a comics website with an admin GUI.

I'd have a table of 'images' that can belong to items in another table called 'comics'

Each comic of course contains many images.

How do I make it so there is a data field in comics that points to several images?

I know that I can have each image point to a single comic, but then what if a single image was a part of more than one comic?

rachel2004

Use three tables:

comics
comicID
comicTitle
etc.

links
comicID
imageID

images
imageID,
imagePath,
etc.

The "links" table will allow you to link your comic books (comicID) to images from the comic books (imageID). It will also allow you to match any given comicID to any number of imageID and vice-versa.

tekky

i would suggest adding an order or place column to the links table so you know the propper image order also 😉

makeshift

not that anyone figured that out before but bravo.

tekky

Originally posted by makeshift
not that anyone figured that out before but bravo.

ironically as sarcastic as I am I cant tell if that is sarcasm or not :evilgrin:

excramasax

Well my friend think you have not reviewed database design....😉

There is a link with basic information about Relationship Database design...

http://www.utexas.edu/its/windows/database/datamodeling/

Check it out!!! You´re talking about many to many relationship (I think..) So there is a way to solve that...

Oh, there is a suggestion about the DB structure....

Excramasax

rachel2004

Originally posted by excramasax
Well my friend think you have not reviewed database design....😉

You´re talking about many to many relationship (I think..) So there is a way to solve that...

Thanks for the link. Maybe you and your friend should check it out as well and see what it says about a many-to-many relationship:

http://www.utexas.edu/its/windows/database/datamodeling/rm/rm4.html
When you're done, we'd all be interested in what you and your friend offer as a solution to makeshift's question.

excramasax

Originally posted by makeshift

I know that I can have each image point to a single comic, but then what if a single image was a part of more than one comic?

Maybe there is a mistake in the keys in the new relationship, and also I have not called them primary keys or foreing keys... There is still another mistake? I am sleepy so I cannot think very well... Maybe it´s time to sleep? 😉

Whatever...good night... gonna review DB class docs...:rolleyes: