Printable View
I want to make a system of tags in a gallery php that I developed currently. My problem is that I do not know how I can store these tags as simply and with more optimize option too. Is there a field type mysql store which allows more words separately? Or else what solutions you would suggest? Thank you in advance
I'll do here at first glance:
GALLERY (ID_GALLERY Primary auto_increment, LABEL)
GALLERY_TO_TAG Table de liaison (ID_GALLERY, ID_TAG)
TAG (ID_TAG Primary auto_increment, LABEL)
After the deep left join
you can also use in (occurence1, occurence2) in your request for selection stitch on several occurrence.
Have Fun.